Query Counting Total - Access 97

  • Thread starter Thread starter SNieves
  • Start date Start date
S

SNieves

I have a query set-up to count employee ID's entered for a
particualr week. The total it's giving me is multiplied by
27. i.e. there are ten entries for week ending 8/2/03 but
the query result states there are 270.

Any help is greatly appreciated.

Thanks.
 
Hi,


You probably have a join that has, as effect, duplicated the rows 27
times. Take a look at the SELECT query (in the designer, revert back from
the Total query to a simple Select query), you should see that the basic
"jointure" ( joint result ) duplicate the records. Your total query see
those too, and just sum them all. Work on the select query to eliminate the
dups, then, transform it back to a total query.



Hoping it may help,
Vanderghast, Access MVP
 
Thank you for your reply! It was a great help and you were
right about the dupes. Any input on how I can eliminate
them.

Thanks
 
Thank you again so much. I looked into it a little further
and I realized that there were 27 employees with the same
job code in one of the tables included in the query, so
the query was counting them 27 times. I just eliminated
that table because I could get the same info from another
table included.

Greatly thankful for your assistance.
Sherry
 
Back
Top