How do I use count in a query in Access

[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

 

[Noëlla Gabriël]

Hi,

maybe uou have to review the links between the tables.

 

[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

 

[Duane Hookom]

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