davetough
asked on
find sum of field and no duplicate records in another field
hello,
i want to run a query to sum the total of qty installed and display no duplicate item numbers.
Item Description is being typed in differently sometimes and it is causing duplicates to occur.
Is there a way to ignore the Item description field?
does not matter which variation of item description displays.
thank you
sample attached
duplicate.mdb
i want to run a query to sum the total of qty installed and display no duplicate item numbers.
Item Description is being typed in differently sometimes and it is causing duplicates to occur.
Is there a way to ignore the Item description field?
does not matter which variation of item description displays.
thank you
sample attached
duplicate.mdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thank you