Help With Dates In Query

Lucy02

Registered User.
Local time
Yesterday, 17:38
Joined
Nov 25, 2005
Messages
36
Hi All

This is pretty urgent so your help would be greatly appreciated! I need to do a query where i can find companies who were telemarketed between the dates of 01/01/2006 and 31/02/2006. When i type this in the criteria box however, it fails to do anything. PLEASE HELP!!!


Many thanks
 
Of course that was completely stupid of me but I have now entered the correct dates and I get no results back which is not true. Does it make any difference that some telemarketing does not have a date for which it was done?

Many thanks!
 
In query Design view, type the following in the criteria for the date field:-

Between #01/01/2006# and #02/28/2006#


Note: The dates inside the # signs must be in the US date format m/d/yyyy.
.
 
Hi Jon the dates entered for the telemarketing are in the format of 05/01/06.
as in the 5th January 2006. Will this make a difference again as i am still getting no results?! I think i am definitly doing something wrong!
 
I think it will help if you can post a database with the date field in a table.

^
 
You are absolutely correct, Rich.

I tested. On a d/m/yyyy system, the # delimiter works in query SQL View, but not in query Design View.

Thanks for pointing it out.
.
 

Users who are viewing this thread

Back
Top Bottom