Use of "Min" in totals field

[fredk]

I have a query that pulls pulls the following three fields:

SubGroupNumber, GroupNumber, CompanyName and Employees.....

In my query, I want to total all the employees for each group number (there may be several subgroupnumbers for each group number. There are times when a user will mis-spell the company name so I may have two seperate company names which causes two seperate records in the result of my query - The query totals employees by GroupNumber - I must also include the companyname. Can I use the "min" in the totals part of the query to eliminate this problem?

Thanks!!

Fred

 

[Clandon]

Fred:

If you must include the company name in the query too, and this is where the duplicate spelling is occuring, you will need to use a min on the company field and the totals. The totals should be the same, so if it takes the min total, it should work. Give it a shot.

Cheryl

 

[fredk]

Thanks Clandon - that seems to be working but just wanted to be sure I was not missing anything - thanks much for the help!!!!

Fred