Using a form to fill in parameters.

S

Simeon Cheeseman

Hi
I have a query and report based on that query which requires 2 parameters to
be filled, a start date and an end date. I was wondering if there is any way
i could use a form to enter both dates on the same screen, as this would make
accessing the report much simpler.
Thanks
Simeon
 
S

Simeon Cheeseman

After quite happily thanking you i find that in using the code i get this
error:
Run-time Error 3075.

Syntax Error (missing operator) in query expression (Transaction Date
Between #12/12/2005# and #12/05/2005#)

Can you tell me what i have done wrong please?
thanks
 
B

Brendan Reynolds

It's the space in the field name. If you have spaces or other problematic
characters in field names, you need to put square brackets around them ...

[Transaction Date] between ... etc.
 
Top