Quey producing out of bound results

[gti_jobert]

Hi all,

I am performing the following query using an ADO connection from Excel;

SELECT [Date], SUM([Batch Qty]) As [Batch] FROM [Speed Fastener Packing] WHERE ([Date] BETWEEN #03/04/2006# AND #05/04/2006#) GROUP BY [Date] ORDER BY [Date]

When I execute this statement in Access it generates The following;

Date Batch
04/03/2006 3463000
06/03/2006 2747000
07/03/2006 2738000
08/03/2006 3867000
09/03/2006 4970000
10/03/2006 6235000
11/03/2006 757000
13/03/2006 2170000
14/03/2006 3864000
15/03/2006 6929000
16/03/2006 3342000
17/03/2006 7017000
18/03/2006 3440000
20/03/2006 985000
21/03/2006 4330000
22/03/2006 7578000
23/03/2006 4367000
24/03/2006 5003000
27/03/2006 3726000
28/03/2006 4383000
29/03/2006 6367000
30/03/2006 4358000
31/03/2006 4840000
01/04/2006 3136000
03/04/2006 1102000
04/04/2006 3000000
05/04/2006 5724000
06/04/2006 1687000

Why is the statement returning results that are not between the dates specified?? The [Date] field in the Db is in format Date/Time Short Date dd/mm/yyyy.

Dont have a clue what I'm doing wrong! TIA, any ideas appreciated!

 

[Jon K]

WHERE [Date] BETWEEN #04/03/2006# AND #04/05/2006#


In SQL statements, Access treats dates delimited by the # sign as in the US date format i.e. mm/dd/yyyy.
.

 

[gti_jobert]

Thank you very much....Have sorted the problem now!