query question about Between

  • Thread starter Thread starter Torpi
  • Start date Start date
T

Torpi

I know this " Between #02/02/2005# And #28/02/2005#" would work, what about
if I want to prompt the user to enter the dates, would this "Between # &
Like [Enter Customer Start date: ] & "*"# And # & Like [Enter Customer End
Date: ] & "*"# work? Help Pls
Torpi
 
Hi,


In the criteria line, type

BETWEEN [Enter Customer Start Date: ] AND [Enter Customer End Date: ]


You need a delimiter only if you type the constant itself, NOT if you use
the name of the container that store the value.


Hoping it may help,
Vanderghast, Access MVP
 
Whar are you trying to do?

I never used Like comparison operator (operating on String values) within
BETWEEN ... AND ... operator (generally for numeric / date values)
 
Back
Top