Enter Prompt Dates into Report

[newton1234]

Hi,

I have a report which is run from a query. when you run the report you are prompted for specific dates.

I was wondering if there was a way of putting the dates you enter in the prompts into the report ?

Hope this makes sense.

Thanks in advance.

L

 

[pbaldy]

You can refer to them in the same way they appear in the query, for instance a textbox control source of:

=[Enter date]

 

[newton1234]

Hi,

Thanks for your reply, however when I enter this into my report and run it, I am prompted for dates, but the dates I enter do not show on the actual report ?? Any Ideas ?

 

[pbaldy]

You should not get an extra prompt; the text in the brackets must exactly match the text in the query.

 

[newton1234]

Thanks, do you know if I have to put any reference to the query which the prompts are in.

My query has prompts called [Start Date] and [End Date].

So in my report I have added a field called =[Start Date] and another called =[End Date]

Is this correct ?

Sorry, I am very new to access.

 

[pbaldy]

=[Start Date]

would be in the control source property of the textbox, not the name. You could actually do this type of thing as well:

="Between " & [Start Date] & " and " & [End Date]

Can you post the db?

 

[SOS]

And as an alternative suggestion - I use a form for my inputs which can then be referenced by the query, report, etc. The benefits also of using a form is that if the user accidentally inputs a wrong date they don't have to type everything all over after having to wait for the report to finish. Also, they can re-run the same report if necessary without having to type the dates over.