A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Between dates?



 
 
Thread Tools Display Modes
  #1  
Old May 23rd, 2004, 06:49 PM
C & J Jones
external usenet poster
 
Posts: n/a
Default Between dates?



"fredg" wrote in message
...
On Sat, 22 May 2004 10:59:00 -0400, C & J Jones wrote:

Hello all,

When using the statement: Between [StartDate] And [EndDate], the

records
returned include those on the start date but no records are returned

from
the same month as the end date.

example: [StartDate] , 01.10.04
[EndDate], 05.22.04
First record returned is 01.01.04
Last record returned is 04.28.04
All records for May are not returned.

Any help would be appreciated.


What happens if you enter the dates in
1/1/2004
5/22/2004
format?
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.


By BAD, that was embarrassing easy, both the"/" and "-" work. I picked up
the habit of using the dot long ago while working with a European supplier
and it has stuck who knew??
Thanks again.

Jim


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:20 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.