report with variable

[pauwer]

::Sorry wrong forum!::
Hi!
I have a table in my database with in 1 collum the date from when th
order is placed, and in another there's the name of the person who sol
it. Now I can make records with all the dates on a page but I'm lookin
for any ideas to make a code for the following: When I execute th
report, I want that access gives an inputbox where I have to give i
the month and the year so I can recieve a report where I can view witc
person sold howmany products in that month.
Thanks in advance!
Pauwer

 

[Eric Cárdenas [MSFT]]

Hi!

I have a table in my database with in 1 collum the date from when the
order is placed, and in another there's the name of the person who sold
it. Now I can make records with all the dates on a page but I'm looking
for any ideas to make a code for the following: When I execute the
report, I want that access gives an inputbox where I have to give in
the month and the year so I can recieve a report where I can view witch
person sold howmany products in that month.
Thanks in advance!
Pauwer

--------------------
You can use an unbound form to enter the month and year for that person.
You can then use a command button that will call the OpenReport action to
run the report with a filter on the sales person and month and year.

Hope this helps,