"unique" report data

  • Thread starter Thread starter Wm
  • Start date Start date
W

Wm

Ref: Access 2K, SQL 2k

Is there any way a report can display unique 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 unique * ...) but I don't if there's a
way to accomplish that without using a stored procedure.

Thanks,
William
 
Oh yea, that's what I meant. But how do I do this? I have tried

MyReport.RecordSource = "select distinct * from MyTable"

but I get a memory exception error and Access crashes.
 
Back
Top