I'm having an issue with a query performing calculations and I hope someone can help me as I'm tearing my hair out!!!
Basically I have a cost form that has 3 different VAT rates in a drop down list. On the form it calculates the value + VAT no problem but when I run a query with the total amount it comes back blank.
Is there something I should be adding into the query? I've tried building an expression in the criteria to calculate all the subtotals but that doesn't work either.
I need to sort this asap as about to go off on leave for a while and no one else knows how to work with the database. I need the reports to be accurate before going.
Any help is gratefully appreciated.