How do I either, create a date field that recognizes a 0 in front of the single digit months? Ie, 01 (January).
Or what do I need to put in the query to get a report of a specific month, that has 1 in the month.
I currently have it set up so the user puts in the month to generate a report, but when they put in 1. They get data for October through January.
Access is currently set up to eliminate the first 0, if you put in a date like 01/01/02.
Simple question, I hope, but I just don't know enough about Access to know the answer myself. Thanks.
jo
Or what do I need to put in the query to get a report of a specific month, that has 1 in the month.
I currently have it set up so the user puts in the month to generate a report, but when they put in 1. They get data for October through January.
Access is currently set up to eliminate the first 0, if you put in a date like 01/01/02.
Simple question, I hope, but I just don't know enough about Access to know the answer myself. Thanks.
jo