date parameter

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

Guest

I have a query built with a "start date" and "end date" parameter. What can
I enter in the "end date" to allow the query to run through "current?"
 
Try this

Select * From TableName Where FieldName Between [Please Enter start Date:]
And IIf([Please Enter End Date:] is null Or [Please Enter End Date:] = "" ,
Date(), [Please Enter End Date:])
 
As an interface issue, I'd suggest that you make the prompt read [Please
Enter End Date or Hit Enter]. This alerts the user to the fact that this
option is available. Of course, Jim might be the only user, in which case,
this is probably not necessary.

--

Chaim


Ofer said:
Try this

Select * From TableName Where FieldName Between [Please Enter start Date:]
And IIf([Please Enter End Date:] is null Or [Please Enter End Date:] = "" ,
Date(), [Please Enter End Date:])
--
I hope that helped
Good luck


Jim said:
I have a query built with a "start date" and "end date" parameter. What can
I enter in the "end date" to allow the query to run through "current?"
Click to expand...
Click to expand...
 
Back
Top