Hi,<br><br>i have a query to run on a table which has these two fields in question: Date shipped and Status; I have the query to run on the Date shipped field to display records in a specific date range, and it does it ok, except that when I specify a criteria for the field "status" ( on my Status field, I have just 2 different records: Delivered or InTransit; if I Also specify the Criteria "Delivered" for the field "status", the query results display all records that have "delivered", ignoring the date range specified in the DateShipped field. What am I doing wrong????
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
QUERY RESULTS NOT RIGHT- PLEASE HELP
- Thread starter HerickP
- Start date
Look at the query in design view. For each column in the query there should be a line for criteria. The line below that has an "or" label. Make sure that both criteria for "Date shipped" and "Status" are entered on the criteria line. If not the query will return the records between the date range OR any with the status specified.<br>
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question