How do I use count in a query in Access

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
 
V

vanderghast

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
 
D

Duane Hookom

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