ONE of us can't count.

[Sue]

I have a query that lists the number of sessions for each client for 2009.
The criteria for "SessionDate" = >=#1/1/2009#. The query runs properly and
lists all sessions for 2009, no sessions EXCEPT 2009, and no duplicate
sessions.

I based a report on that query & have a field that counts the number of
sessions for each client for 2009. The field is "=Count([SessionDate])".

The report accurately counts the number of sessions for all clients EXCEPT
ONE. For this particular client, who has had 6 sessions so far this year,
Access counts 12 sessions.

I've run Find Duplicate queries on the data and checked it manually. There
are ONLY 6 sessions for this client, no duplicates, and the client is listed
only once, so I can't figure out why I'm having this problem.

Please help. I'm pulling my hair out and I don't look good bald.

 

[Golfinray]

Is "session date" text or is it a date datatype? If it is text you need
=count(["session date"]), if a date just =count([session date])

 

[Sue]

It's a date, and I have used =Count([SessionDate]).
--
Thanks for your time!

Is "session date" text or is it a date datatype? If it is text you need
=count(["session date"]), if a date just =count([session date])

I have a query that lists the number of sessions for each client for 2009.
The criteria for "SessionDate" = >=#1/1/2009#. The query runs properly and
lists all sessions for 2009, no sessions EXCEPT 2009, and no duplicate
sessions.

I based a report on that query & have a field that counts the number of
sessions for each client for 2009. The field is "=Count([SessionDate])".

The report accurately counts the number of sessions for all clients EXCEPT
ONE. For this particular client, who has had 6 sessions so far this year,
Access counts 12 sessions.

I've run Find Duplicate queries on the data and checked it manually. There
are ONLY 6 sessions for this client, no duplicates, and the client is listed
only once, so I can't figure out why I'm having this problem.

Please help. I'm pulling my hair out and I don't look good bald.