Sum only first record of group

[RogerC]

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.

[recyan]

Till some one comes along, a few questions :

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.

Do you want

ITEM......................PRICE
X..............................$10
Y------------------------$25

OR

ITEM......................PRICE
X..............................$20
Y------------------------$50

in the footer.

Thanks

[RogerC]

Recyan, this is what I want:

ITEM......................PRICE
X..............................$10
Y------------------------$25

Basically, in the summation, I'm trying to include each item's price only once. So instead of adding all Xs and all Ys, I want to add only one X and one Y (the desired outcome would be $35 for the above example).
Thank you for your response.

[recyan]

Don't know if I have understood things correctly.

You could perhaps, have a sub-report, based on below query, which you could then, incorporate in your main-report.

SELECT DISTINCT myTable.ITEM, myTable.PRICE
FROM myTable
ORDER BY ITEM;

Thanks