Enter Wildcards for Date Parameters

[P5C768]

Found a great post by a forum user here:
http://www.access-programmers.co.uk/...d.php?t=143346



But I'm still wondering if I can enter a wildcard into a date field parameter that uses:

Between [Start Date] and [End Date]

I'd like uses to be able to pick a specific date range, everything before/after a date or just get all records in the database. Is that possible?

[HiTechCoach]

For all enter 1/1/1900 to 12/31/2099 or some range you know will exceed the possible data.

[P5C768]

The users of this database aren't the sharpest tools in the shed (i.e. their most common computer problem is forgetting to turn on their monitor) so trying to explain why they should use dates like that wouldn't go over well.

However, you did solve my problem because I'll just create a button that uses those dates if clicked and call it "All Records" or something that is hopefully self explanatory.

Although I'll provide a user manual, I'm still looking forward to the questions I'll get...

[HiTechCoach]

Are you using parameter prompts in the query?

I find it best to use a form to collect the criteria for reports. I never use parameter prompts in queries. No way to validate the data or help the user.

This might help: Report Dialog Examples