Using a Parameterized Query

[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.

 

[John Vinson]

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.

Try a criterion like

= DateSerial(Year(Date()), [Enter month number:], 1) AND < DateSerial(Year(Date()), [Enter month number:] + 1, 1)

 

[bert]

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

Hope this helps,
Bert

 

[bert]

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

Hope this helps,
Bert

 

[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

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.

.