If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Prompt user to input what data to be displayed on Report
I've created a report. I would like for user to decide what dates they want
to see on report. (I think I need a parameter???? query)? What type of query do I create where user is prompted to enter a 'Begin Date' and and 'End Date'.. and have that data appear on report. What are the steps to do this????? Note: My date is in short date format |
#2
|
|||
|
|||
Prompt user to input what data to be displayed on Report
On Mar 25, 4:00*pm, Summing multiple fields on a form
t.com wrote: I've created a report. I would like for user to decide what dates they want to see on report. (I think I need a parameter???? query)? What type of query do I create where user is prompted to enter a 'Begin Date' and and 'End Date'.. and have that data appear on report. What are the steps to do this????? Note: My date is in short date format Create a select query on citiria between fromdate to enddate Then create the report using this query. Hopes it help.... |
#3
|
|||
|
|||
Prompt user to input what data to be displayed on Report
Thx Hc...but how do I make the query as part of the report???
"HC" wrote: On Mar 25, 4:00 pm, Summing multiple fields on a form t.com wrote: I've created a report. I would like for user to decide what dates they want to see on report. (I think I need a parameter???? query)? What type of query do I create where user is prompted to enter a 'Begin Date' and and 'End Date'.. and have that data appear on report. What are the steps to do this????? Note: My date is in short date format Create a select query on citiria between fromdate to enddate Then create the report using this query. Hopes it help.... . |
Thread Tools | |
Display Modes | |
|
|