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
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