My data is structuredin the following format:
ITEM......................PRICE
X..............................$10
X..............................$10
Y------------------------$25
Y------------------------$25
I would like to calculate each item's price only once in the Access report footer. However, when the SUMformula is entered I get the cumulative price for each item (i.e. $70 asopposed to $35).
Is there any way I could just show the price of the first item of the group only? I'mthinking of creating a new field in a query and adding 1s and 0s, but don'tknow exactly how.
Is there another way of handling this? Thank you all foryour input.