Distinct Records

[Darrick]

Hi,

I am trying to run a query from a table that has dates in
it.

What I want to do is bring up distinct user information
and then add the date. If I include the date with the
rest of the data the query brings back all of the
information.

Any idea how to run a distinct query and then place
additional fields in?

Thanks.

 

[chris]

Create a new query using the distinct query you already
have, and the source table. Link these two sources on the
unique identifier(s) in the distinct query. Then include
the date from the source table.