display a date entered by a user

[deejay_totoro]

Dear all,

I have a query that returns data based on a date.

The user is asked for a date, then every equal to or below that date is returned. For example:

fldDate: <=#01/01/2004#

What I would like to do is to generate a field that will tell me what "less than or equal to date" has been input. I could then show this date on a report, saying something like "This report has been run to [less than or equal to date input]".

Thanks!

dj_T

 

[KenHigg]

Put a hidden field on your form and store it there for the reports use?

 

[Rich]

it's better practice to enter query parameters via a form in the first place, where you can prevent the input of bad data.

 

[deejay_totoro]

Can't use form at present

Hello,

Actually - at this point, I am not allowed to alter any forms at all on this database. I can only use queries/reports to get what I want.

Eventually I will use a form to provide the date input, but for now - I am only allowed to use the queries/reports to get what I need.

Any ideas?

dj_T

 

[KenHigg]

I would do a new db and attach to the source, then do what you want.

 

[deejay_totoro]

Ah!

Thats a good idea - in all my panic I hadn't thought of that. I thought was looking for a more complicated solution.

Thanks.

dj_T