date query problems

[ferde]

I'm a beginner trying to use parameter date queries to obtain September
records only. I tried using the between [start date] and [end date]
parameter query to obtain September records but no records show up.
No records will show up using this SQL

SELECT Count(Query1.Log) AS CountOfLog, Query1.Disposition, Query1.CallDate
FROM Query1
WHERE (((Query1.Disposition)="Remain In Room") AND ((Query1.CallDate)
Between [start date] And [end date]))
GROUP BY Query1.Disposition, Query1.CallDate;


I have even just typed in the specfic dates in order not to get any records
prior to 08/30/2006 but all of my august records show up anyway. See below:


SELECT Count(Query1.Log) AS CountOfLog, Query1.Disposition, Query1.CallDate
FROM Query1
WHERE (((Query1.Disposition)="Remain In Room") AND ((Query1.CallDate)
Between "08/31/2006" And "10/01/2006"))
GROUP BY Query1.Disposition, Query1.CallDate;

Can someone please help a real beginner

 

[Ken Snell \(MVP\)]

Let's stay in the thread that we already have underway. Posting a separate
question doesn't let others see the context of the thread and the
information that has been exchanged.