Parameter Value

[digs]

I've got a report that runs from a query based on absence dates and the query uses a Parameter Value so the user has to enter dates required which is done by Between [Enter Start Date of Sickness Required] And [Enter End Date of Sickness Required]. What I would like to do is get these dates that the user enters to show on the report so you can see what the reporting dates are.

Does anyone have any ideas if this can be done.

 

[ColinEssex]

a search would have found this -

http://www.access-programmers.co.uk/forums/showthread.php?t=39821&highlight=show+parameters+report

Col

 

[Brianwarnock]

Nice find Col
I usually use a form to drive my reports but was curious to see if what was being asked could be done, my search produced lots of results suggesting the use of a pop up form and I gave up. What search did you use?

Brian

 

[ColinEssex]

Brian, I typed in "show parameters on a report" then just flicked through the answers till I found the suitable one.

However, when I put parameters on my report header I just make a textBox in the header and put the parameter in there exactly as its written in the query.

ie

[Enter Start Date]

then another TextBox for the end date and put in

[Enter End Date]

Col

 

[Rich]

But can you trust users to enter the parameters correctly?

 

[ColinEssex]

The users can be all over the place when it comes to common sense

So at least when the dates are printed in the header, they can see that they typed it in wrong.

I suppose there are fors and againsts using the query type parameters in the square brackets [] versus the popup form with the textBox and little calendar style.

The other way may be that if you have a monthly report that is always a previous full month (1st day to last day) then a ComboBox selecting just the month name (and year) may be better

Col

 

[Brianwarnock]

Thanks for your response Col, I think I'll stick to using a Form but it's nice to know the alternatives.

Brian