Returning too many results

B

BMcCue85

I have several queries that give me rate, yield etc but when I try to create
a separate query that pulls in the information from those queries I get
exponentially more results than I need. I want to narrow it down by machine
and date but when I do it gives me the same answer 10 times. How can I create
the query where it gives me only the information i want one time like yeild
for machine 3 in january?
 
J

Jerry Whittle

Show us the SQL for the queries involved. Open the query in design view.
Next go to View, SQL View and copy and past it here. Information on primary
keys and relationships would be a nice touch too.

Or you can try to turn the last query into a Totals query. That should get
rid of the dupes. While in query design view go up to View and select Totals.
 
Top