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