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
Inappropriate post?
If so, Red Flag it!
Check out the FAQ
area for this forum!
Tek-Tips Forums is Member Supported. Click Here to donate.
mp9 (Programmer) Nov 20, 2002
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?
Mark this post as a helpful/expert post!
Inappropriate post?
If so, Red Flag it!
Check out the FAQ
area for this forum!
Bickertk (Programmer) Nov 20, 2002
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
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
Inappropriate post?
If so, Red Flag it!
Check out the FAQ
area for this forum!
Tek-Tips Forums is Member Supported. Click Here to donate.
mp9 (Programmer) Nov 20, 2002
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?
Mark this post as a helpful/expert post!
Inappropriate post?
If so, Red Flag it!
Check out the FAQ
area for this forum!
Bickertk (Programmer) Nov 20, 2002
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