When I do a query (Design View) in Access using only one Table with
criteria and look at the SQL, the keyword is WHERE. However, when I do
a query in Access using joined Tables with criteria and GROUP BY and
look at the SQL, the keyword is HAVING instead of WHERE. Also, the
GROUP BY clause comes before the HAVING clause.

It might be easier to do the query in the db app, e.g. Access, in
order to get a firmer grasp on the SQL.

Hth,
Merjet