Report calculations

[gucci]

Hi, In my report I have VAT Amount calculated.
=[AmountExVAT]*[VRate]
Then when I try to add the SUM of the VAT Amounts Controls I use this
=Sum([VATAmount])
But it does not work, Why?

Thanks

 

[pbaldy]

You can't sum a control. Try:

=Sum([AmountExVAT]*[VRate])

 

[gucci]

the VRate can be different values. Will =Sum([AmountExVAT]*[VRate])
work then.
Thanks for the quick reply.

 

[pbaldy]

Did you try it?

 

[gucci]

Yes I tried it and it works.
Thanks a mill I just have one other issue to solve. I posted a thread about it already but no answer so far that works. Maybe you could help.
here the thread link
http://www.access-programmers.co.uk/forums/showthread.php?t=125654