Monthly Reports

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

Guest

Ok, So I have a database that has all of our order records. I have created
several reports, however I am having problems with the following report: I
want to prompt the user for a specific month and a specific year, and
retrieve all the orders that were entered during that month and year only. (I
have a order date field in my my table). I have successfully created a
report by hard-coding the dates that I need, but I wanted to create a more
flexible report.

Thanks for any help....
 
Hi Greg,

You can create a parameter query and use it as the record source for your
report. You can have the query prompt the user for month and year. You
might need to play around little, something like this. Create 2 new fields in
your query.

newfld1:datepart('m',[order date])
newfld2:datepart('yyyy',[order date])

Then, in the criteria fields for your new fields, enter something like:

[enter order month]
[enter order year]

Hope this helps.
 
Back
Top