Report Out put not same as Query Result 1

[kentwoodjean]

I have a query that when it runs, does exactly what I want it to do. Basically, I have employees entering information on a form following each telephone call. Along with basic info from the main table, this query also includes call type and type discription from 2 other tables. Again, when I run the query, it runs correctly. The only parameter shown is that of "Between [First Date] And [Last Date]. I ran the report wizard using all pieces of my query and requested that the report entries be grouped by name of employee. The report will duplicate each entry multiple times, unlike the query. Why is this happening and how can I stop it.

 

[PaulBricker]

Sounds like a Join problem but I'm a little unclear what you mean by "The report will duplicate each entry multiple times, unlike the query.". Do you mean you are getting the same Records over and over again. If that's the case it's usually a join issue, especially if its a query with multiple tables. But you say you don't see that in the Query.
The only other thing I can think of is Grouping on Employee Name. Do you have Employees with the same name? Can you post the SQL from the underlying query. That might help.

Paul

 

[Underling]

Ok this is a realy slopy way of getting around the problem if you can't be assed trying to fix the join.
Take the "between" paramete out of the qurey and write another query of the first, adding back in the "between" parameters.
Then run the Report off the second query, sloppy, you bet, dose it work. All the times that I have done it.
I do go back when I have time and clean it up but if you are in a hurry, it will do
Hope this is some help.