How do I use count in a query in Access

  • Thread starter Thread starter FM
  • Start date Start date
F

FM

Hi,

I created a query to count number of people attending training sessions.
each participant in the database has a unique ID number. When I run the query
the total number of participants attending each of the training session is
doubled. What am I not doing right?

Thanks,
FM
 
The query you use may involve a JOIN which 'double' each record.

Try the query, without the GROUP BY and without aggregate (SUM,
COUNT,.... ), just

SELECT *
FROM ...
WHERE ...


and see if, indeed, with this query, the records are doubled.


If you don't see why, you may post that simplified query (its SQL, as view
in SQL view). Maybe someone would be able to see what is the possible
problem.


Vanderghast, Access MVP
 
It would help if you described the significant tables, fields, relationships,
and the SQL of your query.
 

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

Append Query Issue 0
Add percentages 1
Count Yes/No with Criteria 2
query working very very slow 1
[Select] the results of 2 queries 2
Unmatched query question 3
Filter by date in query 8
How do I count non-duplicated records in a query in Access? 1

Back
Top