Parameter Date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I currently use a parameter query (in an Access query grid) that has a pop-up
that asks for a date. Is there a way to have it automaticly use today's date
if the user leaves the pop-up parameter blank? Almost all the time we are
dealing with today's date. We have plenty of parameter queries. I am just
trying to streamline their Access experience and yet keep it flexable.
Any help is greatly appreciated.
 
Use the NZ function

Field: [Some Date field]
Criteria: Nz([What date should I use?],Date())
 
Works like a charm. you've earned a glod star today! thanks!!

John Spencer said:
Use the NZ function

Field: [Some Date field]
Criteria: Nz([What date should I use?],Date())


jackle said:
I currently use a parameter query (in an Access query grid) that has a
pop-up
that asks for a date. Is there a way to have it automaticly use today's
date
if the user leaves the pop-up parameter blank? Almost all the time we are
dealing with today's date. We have plenty of parameter queries. I am just
trying to streamline their Access experience and yet keep it flexable.
Any help is greatly appreciated.
Click to expand...
Click to expand...
 
Back
Top