Using a Parameterized Query

  • Thread starter Thread starter tim mcmurray
  • Start date Start date
T

tim mcmurray

I have set up a database that has a month billed field
and I want the user to be able to lookup just the month
value through a parameterized query when a report is
opened.
 
I have set up a database that has a month billed field
and I want the user to be able to lookup just the month
value through a parameterized query when a report is
opened.
Click to expand...

Try a criterion like
= DateSerial(Year(Date()), [Enter month number:], 1) AND < DateSerial(Year(Date()), [Enter month number:] + 1, 1)
Click to expand...
 
month([billingdate])=[enter billing date] and year([billingdate])=[enter
year]

Hope this helps,
Bert
 
month([billingdate])=[enter billing date] and year([billingdate])=[enter
year]

Hope this helps,
Bert
 
Thanks a lot for the help it works like a charm.

Tim

-----Original Message-----
month([billingdate])=[enter billing date] and year ([billingdate])=[enter
year]

Hope this helps,
Bert




tim mcmurray said:
I have set up a database that has a month billed field
and I want the user to be able to lookup just the month
value through a parameterized query when a report is
opened.
Click to expand...






.
Click to expand...
 
Back
Top