handlebars
Technical User
I have a view made up of 6 underlying views that all need to accept the same date parameters from an Access Form.
What I was thinking was to have one table that holds date values and is updated each time the form is closed (before running the report).
These two values would then make up the between parameters in the WHERE part of the query.
What I am not sure about is how to reference date variables in SQL server.
Can anyone suggest the correct syntax to do this?
Any help would be appreciated.
Andrew
What I was thinking was to have one table that holds date values and is updated each time the form is closed (before running the report).
These two values would then make up the between parameters in the WHERE part of the query.
What I am not sure about is how to reference date variables in SQL server.
Can anyone suggest the correct syntax to do this?
Any help would be appreciated.
Andrew