Parameter Query - ms access 97 question

[Salisha Khan]

I have this query that i have created using the query design view. One of
my field is a date field and teh criteria for that field is as follows:
Between [Type the beginning date:] And [Type the ending date:] So basically
two pop up boxes come up prompting the user for a Beginning DAte and Ending
Date. Is there any way that I can put two default dates in the two pop up
boxes. So for example the user did not feel like entering any dates, I can
default the beginnign date to 1/1/1990 and the Ending Date to 1/1/2003.....
Any help will be appreciated.
Thanks
Salisha

 

[John Spencer (MVP)]

What you can do is use the NZ function and return default dates, but they won't
show in parameter box.

Between NZ([Beginning Date (blank = 1/1/1990)],#1/1/1990#) AND ...

No.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

I have this query that i have created using the query design view. One of
my field is a date field and teh criteria for that field is as follows:
Between [Type the beginning date:] And [Type the ending date:] So basically
two pop up boxes come up prompting the user for a Beginning DAte and Ending
Date. Is there any way that I can put two default dates in the two pop up
boxes. So for example the user did not feel like entering any dates, I can
default the beginnign date to 1/1/1990 and the Ending Date to 1/1/2003.....
Any help will be appreciated.
Thanks
Salisha

 

[Salisha Khan]

Thank you very much. I will do that.
Salisha

What you can do is use the NZ function and return default dates, but they won't
show in parameter box.

Between NZ([Beginning Date (blank = 1/1/1990)],#1/1/1990#) AND ...

No.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

I have this query that i have created using the query design view. One of
my field is a date field and teh criteria for that field is as follows:
Between [Type the beginning date:] And [Type the ending date:] So basically
two pop up boxes come up prompting the user for a Beginning DAte and Ending
Date. Is there any way that I can put two default dates in the two pop up
boxes. So for example the user did not feel like entering any dates,

I
can

default the beginnign date to 1/1/1990 and the Ending Date to 1/1/2003.....
Any help will be appreciated.
Thanks
Salisha