ONE of us can't count.

  • Thread starter Thread starter Sue
  • Start date Start date
S

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.
 
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])
 
It's a date, and I have used =Count([SessionDate]).
--
Thanks for your time!


Golfinray said:
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 said:
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.
Click to expand...
Click to expand...
 
Back
Top