Allen,

Again, thanks for the Help and after all that you are correct I will do it
in a Form with other Criteria as the users now want extra's.

Regards,

Ross

"Allen Browne" wrote in message
...
You cannot assign a default value to parameters in JET, but you can craft
the criterion so as to use a specific value if left blank.

The expression in the Criteria row under your date/time field would be
something like this:
= IIf([StartDate] Is Null, Date() - 7, [StartDate])

Be sure to declare the parameters (Parameters on the Query menu), so JET
knows it's a Date/Time type. It will not work correctly if JET treats it
as a text value.

To be honest, I rarely use parameters like that. If you use a form, you
don't get multiple parameter boxes popping up one after the other, you can
choose which ones to use more easily, you can set default values, you can
use combo boxes, you can validate sensible entries, and you can more
easily build filter strings for forms/reports to ignore the boxes the user
left blank. Here's an example:
http://allenbrowne.com/ser-62.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Ross" wrote in message
...

I want to create a query that offers a Default in the criteria under a
Date field, for example:

[Enter Date From] "default as Date today -7"

This will allow the user to either press Enter for all records a week
ago or type in the Date Required.