ONE of us can't count.

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.
 
G

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])
 
S

Sue

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...
 

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

Similar Threads

Can't count. 2
ONE of us can't count. 7
count record 6
Yes/No 7
count record on subform 0
Count YES/NO Field 2
I'm stuck on developing a system to "flag" when 2 criteria are met 2
Count detail only if it's different than other details in a group 0

Top