thank you to all of you for this great site!
I have a report that's based on a parameter query using a start date and end date. If the user enters 9/8 when prompted for the date, the query works but they want the year to be required ie 9/5/2012. It works without typing in the year, using general date and short date formats. How can I format it so that it will NOT work with just 9/8? Access 2010, windows 7
Thank you
jojo
I have a report that's based on a parameter query using a start date and end date. If the user enters 9/8 when prompted for the date, the query works but they want the year to be required ie 9/5/2012. It works without typing in the year, using general date and short date formats. How can I format it so that it will NOT work with just 9/8? Access 2010, windows 7
Thank you
jojo