Setting Query Criteria

[vanny]

Hi,

I am working on a query and wish to do the following criteria:
TargetShipDate
Like < */07/2008

Where I would like as an output only the targetshipdates which are smaller than july 2008 thus in the range between 01-01-2008 till 31-07-2008.

Can someone help me pls to set the criteria properly ?

Thanks.

 

[maxmangion]

try:

Between #01/01/2008# And #31/07/2008#

 

[vanny]

It seems that it is not working properly as no data was given.

When i changed it to read #01/01/2008# OR #31/07/2008# only July data was given

 

[maxmangion]

if you use OR, you will return only records which either have 01/01/2008 or 31/07/2008 and you won't return anything in between.

When you tried: Between #01/01/2008# And #31/07/2008# ... what did you get ?

 

[vanny]

Now it is working perfectly.

Thanks a lot for your help

 

[maxmangion]

You're welcome