Query with Multiple Criteria

[highmeh]

Hi all,

I'm working on a purchasing app in access. At this point i'm working on the reporting module. I want a user to be able to fill out a start date (text box), end date (text box), and select a code from a list, hit Run Query, and have it pull up a report listing the date that the selected code was used, between the start and end date, and display other info as well.

The problem i'm having is that i can get the date ranges to work, or the code to work, but not both of them. Here's what i have in my query:

I'm really lost here. Any advice would be appreciated.

 

[edtab]

What error message are you getting?

 

[highmeh]

No error message, it just returns no rows. For instance, i have a purchase order dated 8/23/06 with the code IM. If i run a query for dates between 8/22/06 and 8/24/06 with the IM code, it returns a blank query window.

 

[edtab]

I use date ranges to filter reports with no problems.
If you post a your db (limited records), I will look into it.

 

[thart21]

You might try placing the criteria for the "Date" field in the next criteria field below it.

 

[boblarson]

Thart21: If you put the criteria in the next criteria field below it becomes an OR and not an AND.

Highmeh: If possible, you might want to do like edtab suggested and post a stripped down version of your database so we can check it out.