monthly report that requires a varible

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

Guest

Each month, after our statements are imported into our database, our
accountants run a report on our conference calls. Before they run the report
I must remember to change the query to reflect the month being searched.

Is there a way to create a report that will give the accountants a dropdown
menu (using our "statement month" field) so they can choose a month, so I no
longer have to change the query each time?
 
What type of field is this? What is currently in your criteria? Assuming
your criteria looks like:

02

then you could simply change it to


=[Enter month 01=Jan, 02=Feb, etc.]

or similar.
 
The field is a text field and each month there is just on date for every
entry (the date the statement is run)

Example:
20-JAN-2006
23-DEC-2005
23-NOV-2005

I'm new enough to this I will need to know how to triger it.

Rick B said:
What type of field is this? What is currently in your criteria? Assuming
your criteria looks like:

02

then you could simply change it to


=[Enter month 01=Jan, 02=Feb, etc.]

or similar.

--
Rick B



EdLeeYoung said:
Each month, after our statements are imported into our database, our
accountants run a report on our conference calls. Before they run the
report
I must remember to change the query to reflect the month being searched.

Is there a way to create a report that will give the accountants a
dropdown
menu (using our "statement month" field) so they can choose a month, so I
no
longer have to change the query each time?
Click to expand...
Click to expand...
 
Can this even be done?
I build a combo box (to hold the dates) in the report...in the cobo box
properties, the event tab brings up nothing (it's blank)

EdLeeYoung said:
The field is a text field and each month there is just on date for every
entry (the date the statement is run)

Example:
20-JAN-2006
23-DEC-2005
23-NOV-2005

I'm new enough to this I will need to know how to triger it.

Rick B said:
What type of field is this? What is currently in your criteria? Assuming
your criteria looks like:

02

then you could simply change it to


=[Enter month 01=Jan, 02=Feb, etc.]

or similar.

--
Rick B



EdLeeYoung said:
Each month, after our statements are imported into our database, our
accountants run a report on our conference calls. Before they run the
report
I must remember to change the query to reflect the month being searched.

Is there a way to create a report that will give the accountants a
dropdown
menu (using our "statement month" field) so they can choose a month, so I
no
longer have to change the query each time?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top