query question about Between

[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

 

[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

 

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

 

[Torpi]

Hi Micheal,

It works Thanks Y'all