Queries give me information I don't want

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have tried to run a query with date parameters. When I try this, I get
some of the dates I want plus dates which aren't in the parameter I
requested. How do I fix this? Also within the same query, I've tried to ask
for data associated to specific names, example: sales between 1/1/05-6/30/05
for salesman Johnson. I'll get some correct dates, plus wrong ones and names
I didn't ask for. Where did I go wrong?
 
OK, can you copy and post the SQL of your query?

Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message
 
Back
Top