AnsweredAssumed Answered

SHOW ALL VALUES WITHOUT REPEATITION

Question asked by DranLang on Aug 29, 2013
Latest reply on Aug 29, 2013 by DranLang

Title

SHOW ALL VALUES WITHOUT REPEATITION

Post

     Hi good morning to everyone!  Just a question about displaying the values from a table.  I have a table in place which contains ID# (Field), Item Description (Field), Price (Field) and Qty (Field), I want to create a report which will display all the Item Description with its corresponding Price and Qty. Everyday of the week I create this report, so there are Item Description that will appear on some days and won't appear on some days for 6 days.  I want to display all of the Item Descrition with its Price and Quantity without having to see the same Item Description which means if there are any the same Item Description their Qty will be added all together to avoid having to see the same item displayed repeatedly.  How can I do this?

     Thank you everyone!

Outcomes