Individual Records

[JanisB]

I have a query that pulls together data from multiple tables based on an ID that . The ID may have one record relating to it, it may have many. The query should only output the FIRST record for each ID number i.e. one row per ID number, despite how many other records may rleate to it. Is this possible?

[Datagopherdan]

If you have some type of Auto-ID field in the related tables then you can just do something like this. We'll call the unique ID in the related table "UniqueIDField", which would be an auto-number and the field that you use to set your relationship on "RelatedIDField"

SELECT First(Table1.UniqueIDField) AS FirstOfUniqueIDField, Table1.RelatedIDField
FROM Table1
GROUP BY Table1.RelatedIDField;

This will give you the first entry for each related record based on the sequential auto-number id.