Parameter Queries

[ckirmser]

Is there a way to label a parameter in a query?

I need to enter a start date for a query - the parameter - and the end date is always six months later.

Currently, I use;

Between [Enter Start date:] And [Enter End date:], but this is not idiot-proofed.

How can I make the second parameter be a calculation based upon the first; i.e., [First Param] + 180 days?

Thanx for any help!

 

[boblarson]

The best way to handle parameter queries is to use FORMS for user input as you have a whole lot more control. In fact, you can have your user put in the start date and then using code you can set the ending date to 6 months later using the DateAdd function but still allow your user to change it. Or, if they shouldn't change it, you can lock the text box for the ending date or even not display it.

 

[ckirmser]

Query by form. I should have thought of that. Heck, the dialog that comes up by a parameter query is just a kind of form, only automated by Access...

Danke!