displaying parameters

[viral_patel1981]

I'm entering two parameters i.e date ranges

i want to display this on a form or report.

can you help please?

 

[KenHigg]

The easiest solution is to have a popup form where you enter these dates and use them as params and then ref them on the report.

Ken

 

[ColinEssex]

to display on a report put a textbox in the header with a control source of:

="From " & [Enter start date] & " to " & [Enter end date]

Make sure the 2 criteria have the exact same wording as the criteria in the query or it will prompt for an input.

Col

 

[viral_patel1981]

we are pulling the date ranges in from an excel sheet, which we have linked into access. so in effect we enter the two params into excel and then this will link back to the access database and pull the data.

the problem we have is we cant think of a command for access to look at the excel table and the columns with the dates in and display them in a report or form