date query problems

F

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 :)
 
K

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top