query question about Between

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
 
M

Michel Walsh

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
 
V

Van T. Dinh

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)
 
Top