I have a table with the following fields:

ITEM
TOTAL
REF

The data is imported from Excel & the value in the ITEM field may be
repeated for an instance in the REF field.

So for 3 different REF values, the ITEM values may appear up to 3 times.

Is it possible to produce a query which will show the total for each ITEM,
rather than each instance?

Thanks in advance.