Grand total is wrong wrong wrong!!

[Switchwork]

Please you gotta help me with this as I have been working on this since 7:30 am. I had to re do the design of my invoice report. Basically I have a subtotal which adds together the Total cost I used the Summary part in the report wizard to do this part. I then had to add a calculated text box for the VAT which I did and it was great. I then had to generate the Grand total. you know Subtotal + VAT. Which I did and that also worked well. BUT.... The first Invoice i produced was for a customer that we had completed only one job for. The figures below:
Subtotal=£45.00
VAT=£7.88
Grand Total= £52.88

This is good and correct. However when I wanted to generate my nex customer invoice that we had done numerous jobs for I am getting the following :
Subtotal= £1,122.35
VAT= £196.41
Grand Total = £232.34 ?????
What is up with the grand total?? The first two figures are what they are supposed to be but the grand total is totally WRONG!! I just cannot even figure out how on earth it calculates that amount?? The expression used is still the same as the expression used for the first invoice which is this:

=[TotalCost]+[VAT]
This formula calculates the correct result for the first invoice but then calculates incorrectly for the invoice with more jobs on it. The only difference between invoices is that there is alot more jobs on them so the subtotal figure is bigger and I suppose it actually has to add all the job prices together. However I never had any problems with the invoice on my old database and it was exactly the same.
Can anybody help me with this. Just an idea what is going on with this.

Thank you in advance and please please help me with this :

 

[Kraj]

My best guess is the location of the subtotal field is screwing you up. Is there a single invoice amount that adds with the VTA to make the grand total it shows you? At first guess, it sounds like the subtotal field is only accepting a single value, maybe the first value only? Is it in the details section of the form or subform? Try moving it to the footer or maybe onto a new subform and see what happens.

That's just my guess.

 

[WayneRyan]

Switch,

Try moving it to the footer and changing it to:

=Sum([TotalCost]+[VAT])

Wayne

 

[KenHigg]

Is this still a problem?