filtering non-unique records in a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to create a query that returns a list of clients we've had within
a certain date range. However, I would like it to filter those results so
that each client only shows up once. Is this possible? I've been trying
using Select queries with the UniqueValues setting set to yes, but I still
get duplicate client names.

Any ideas?

Thanks
 
Dear Enterprise:

If you show more columns than just the client (what? name? number?) then
you will get UniqueValues of all the columns you show COMBINED. If you were
to show ONLY the client column(s) you would not have duplicates showing.

I expect you are filtering an aggregate query by the MAX(SomeDate) Uncheck
the box to SHOW this column with the MAX(SomeDate) and that may be enough to
fix it.

Tom Ellison
 
Back
Top