SHOW ALL VALUES WITHOUT REPEATITION
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!