Running report with a query

G

GeorgeH

I am stumped....I am running a report from a query. I have verified that the
query is running perfect. If in the report, I select as the records souce
the query, the query still runs find. However, when I run the report on
groups I am getting some duplicates. I have not seen anything in the
underlying query or records to cause this. So....I tried creating the
records souce differently. In left the souce blank, they did a SELECT
selecting the same query. Now when I run the query I am picking up these
same duplicates. In other words, if seems there is something unique that
access is doing in the "SELECT" mode that is causing this duplication.

Can anyone HELP!!!
 
Top