Search results

I have used an expression build to basically do a tax calculation. its abit like this [Cost ex VAT]*(1+[Valueaddedtax]![VAT]/100). right this should give a value with tax add and it does but not in a currency format? the field isn't in a table so i can't format it like i would do in a table...

Right basically what i'm tryin to do is .... i have a table tblConstants this has one field in which holds a TAX value. I'm wanting to use the value in the query this is what i have entered using the expression builder Cost inc VAT: [Unit Price]*[No Of Items]*(1+[tblConstants]![VAT]/100)...