We help IT Professionals succeed at work.

find sum of field and no duplicate records in another field

davetough
davetough asked
on
316 Views
Last Modified: 2012-05-11
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
Comment
Watch Question

MS Dynamics Developer
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
am i right- then if I want item description- I will have to join it to this data after I first run this query?
thank you
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.