I have a query that pulls data from 3x tables. For one of those fields I would like to output only one instance of a field (it is email address data).
I expected I could use the First function in grouping by including a date-time stamp field and sorting it in reverse order so that the "first" occurrence would indeed be the latest entry but when I run the query all records are still returned. Have not used grouping to do this before but read somewhere that it may be a solution to creating a unique query based on a single field value (vs the entire record).
Goal: output a query as unique for ONE field value contained in the results
(this is in Access 2003 BTW, in case that is a factor)