How do I combine 2 fields in Microsoft Access (1 Viewer)

[BLIT2014]

As a query?

ItemID Brand Description Quantity StoreId
106
103 920
103 199



I'd like to add 920+199 and have only one entry for 103

 

[BLIT2014]

Combine the quantity for
orders with the same ItemID.