< Date

[LDL]

I need the proper syntax for the criteria in a date field of a query. It
would allow the user to enter a date when the query runs and it pulls
records before or less than that date. Thanks, Diane

 

[Ken Snell]

<= [Enter the ending date:]

 

[LDL]

Thanks, Ken. I'm always amazed at the knowledge here. I have never failed
at getting an answer when I post. Thanks for offering your expertise for
free! Diane

<= [Enter the ending date:]


--
Ken Snell
<MS ACCESS MVP>

I need the proper syntax for the criteria in a date field of a query. It
would allow the user to enter a date when the query runs and it pulls
records before or less than that date. Thanks, Diane

 

[Ken Snell]

You're welcome.

Thanks, Ken. I'm always amazed at the knowledge here. I have never failed
at getting an answer when I post. Thanks for offering your expertise for
free! Diane

<= [Enter the ending date:]


--
Ken Snell
<MS ACCESS MVP>

I need the proper syntax for the criteria in a date field of a query. It
would allow the user to enter a date when the query runs and it pulls
records before or less than that date. Thanks, Diane