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

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.

--

Ken Snell
<MS ACCESS MVP>

"ferde" <(E-Mail Removed)> wrote in message
news:9386C71D-ECB9-4B86-84EC-(E-Mail Removed)...
> 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