You have not applied the filtering condition in your query correctly.
The Where Clause in a query filters records.
The Having Clause in a Totals Query filters returned results.
So to filter records, you have to put the record selection criteria in the Where Clause of the query, not in the Having Clause.
.
The Where Clause in a query filters records.
The Having Clause in a Totals Query filters returned results.
So to filter records, you have to put the record selection criteria in the Where Clause of the query, not in the Having Clause.
.