Search code examples
ms-accessparametersms-access-2007default

Adding a default for a parameter query in MS Access 2007

I have a report query that asks users for two parameters. One of these parameters is a date. Is it possible to have a non-answer (i.e., the user presses the "OK" button without having entered a date) default to Today()? If so, how?

Solution

  • A better solution:

    Set [What is the date?] as the first criteria, and Date() as the second (Or) criteria!