W
Wm
Ref: Access 2K, SQL 2k
Is there any way a report can display distinct column data? I allow my
users
to filter the data in the report by a number of criteria -- this part goes
into the filter string when I call OpenReport from VBA. Sometimes the
results are lots of the same information from the RecordSource. I would
like the record source to be "select distinct * ...) but I don't if there's
a
way to accomplish that without using a stored procedure.
Thanks,
William
Is there any way a report can display distinct column data? I allow my
users
to filter the data in the report by a number of criteria -- this part goes
into the filter string when I call OpenReport from VBA. Sometimes the
results are lots of the same information from the RecordSource. I would
like the record source to be "select distinct * ...) but I don't if there's
a
way to accomplish that without using a stored procedure.
Thanks,
William