How can I tell a report to show data for a specitic month of the y

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

Guest

Hello;

I am using Access 2002 with XP. I have a database with a field called
"Month" plus other fields containing various data. I have created a report
to pull data from a query but the report displays records for all months of
the year.

I am trying to make it so when I open the report a box will ask me to "Enter
the month". I would then enter "2" for February, etc. and click OK then the
report would only display the records for month 2 (February).

Can anyone tell me how to do this? Thanks for your help - have a great week!
 
Bill said:
I am using Access 2002 with XP. I have a database with a field called
"Month" plus other fields containing various data. I have created a report
to pull data from a query but the report displays records for all months of
the year.

I am trying to make it so when I open the report a box will ask me to "Enter
the month". I would then enter "2" for February, etc. and click OK then the
report would only display the records for month 2 (February).
Click to expand...


Use a query for the report's record source. Set the month
field's criteria [Enter Month]

That is a rather quick and dirty way of doing things, so
when you get to the point of beefing up your application,
think about using a form with a text box for users to enter
the month and a button to open the report.

You will also need to consider the issue of which year the
month is in???
 
Marshall - Thanks for your help, I will try your suggestion.
--
Regards,

Bill Artman


Marshall Barton said:
Bill said:
I am using Access 2002 with XP. I have a database with a field called
"Month" plus other fields containing various data. I have created a report
to pull data from a query but the report displays records for all months of
the year.

I am trying to make it so when I open the report a box will ask me to "Enter
the month". I would then enter "2" for February, etc. and click OK then the
report would only display the records for month 2 (February).
Click to expand...


Use a query for the report's record source. Set the month
field's criteria [Enter Month]

That is a rather quick and dirty way of doing things, so
when you get to the point of beefing up your application,
think about using a form with a text box for users to enter
the month and a button to open the report.

You will also need to consider the issue of which year the
month is in???
Click to expand...
 
Back
Top