i am having trouble adding the total up for my report.

i have one field which displays the price of the car rental.
i then have another part to the report which displays the prices for the extra items. there can be four different extra items added.

i want to be able to make up a sub total of all of the extra items and then a complete total of the car price and extras total price.

at the minute i have completed the car price field, but i am having trouble creating a field that will total up all of the subtotals of the extras.

as can be seen on the screen shot the total field is only totalling up the price of the car and one of the subtotals of the extras

can someone please help
thankyou

What method are you using to calculate the total, ie: Query, VBA, etc.

And if you are using an event, which event are you doing the calculation in?

What method are you using to calculate the total, ie: Query, VBA, etc.

And if you are using an event, which event are you doing the calculation in?

to calculate the car price and the subtotal for the extras i am simply using a query and the code can bee seen on the screen shot that i have taken

thanks for the interest

The query seems to be calculating the subtotals correctly but it appears that the grand total calculation is being done somewhere in the report. How and where are you doing that calculation?