Using a form to fill in parameters.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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.
 
Back
Top