Query Criteria

[Bickertk]

I have had help on this before but I am still having problems.

I have a table of car information included are the following colums.

Registration No Taxation Class Taxation Date


The taxation date is a dropdown box and includes dates as follows, Jan, Feb. Mar, Apr, Etc.

I want to make a report from a query to identify which vehicles want taxing in any one month. SO, I have made a query with these three headings.

In the criteria box for the Taxation Date I have put [Enter Taxation Date]. However, when I run it I get nothing. If I run the query with no criteria I get a full list.

Is this because of the Combo Box.

Can anyone help????

Thanks in advance

 

[mp9]

In the criteria box for Taxation Date, the criterion should read:

=[Enter Taxation Date]

i.e. NOT

"[Enter Taxation Date]"

Can you confirm whether this is causing the problem?

http://www22.brinkster.com/accessory/

 

[Bickertk]

Thanks for the help. The way you say the criteria should be written is exactly how I've entered it, but this is not working. Do you have any other ideas?

Regrads

 

[Bickertk]

Please guys I need more help with this?