Nope i put that I tried that in the first post, it errors and doesn't work I'm afraid

Hey sorry I forgot to mention what i'm trying to get out of it, I'm creating a query so that I can make a report based on a transaction number that will display what items the customer has chosen and a final total price. I know it's bad practice to store the total price so I'm trying to put the sum in the query

so basically I need a recipt in the form of a report with a total price on it

I'm not at my computer at the...

i think im confusing myself here but ill try my best to explain

i have a form where cds can be purchased, within it is a subform which allows a user to choose from a combo box of all the cds

Now i got a textbox to display the sum of the prices using =sum([prices])
but i need to put that sum into a query, i understand you can do the total: [price1]+[price2] in order to add prices up but because my prices are based within...