Hi -
I know this is probably incredibly easy, but I'm either searching wrong or completely missing something.
I am using the Expense Reports template and have modified it for what I need. It's all working just fine except...(btw, Access 2003)
There is a form to "view reports" that has two fields: begin date and end date.
I would like to set the begin date to a specific date (beginning of our fiscal year, 9/1/09) so that i don't have to type it every time.
All I can find when searching is how to set the default value to various things, like today's date, or the beginning of the current month, etc.
I need to be recognized as a date in order for the report query to work correctly.
Any ideas?
Thanks!
I know this is probably incredibly easy, but I'm either searching wrong or completely missing something.
I am using the Expense Reports template and have modified it for what I need. It's all working just fine except...(btw, Access 2003)
There is a form to "view reports" that has two fields: begin date and end date.
I would like to set the begin date to a specific date (beginning of our fiscal year, 9/1/09) so that i don't have to type it every time.
All I can find when searching is how to set the default value to various things, like today's date, or the beginning of the current month, etc.
I need to be recognized as a date in order for the report query to work correctly.
Any ideas?
Thanks!