date parameter

[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?"

 

[Guest]

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:])

 

[Chaim]

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

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

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?"