Access 2003:percentage calculations

M

mcnaugg

How do I calculate VAT (14%) in a query. Do I use something like :
[ItemCost]/100*14 or can I use the % input i.e. [ItemCost]*14%

Gareth
 
J

John Spencer

I would use
[ItemCost] * .14


'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
 
M

mcnaugg

Hi John

Thanks

I never thought of such a simple method.

Regards

Gareth

John Spencer said:
I would use
[ItemCost] * .14


'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

How do I calculate VAT (14%) in a query. Do I use something like :
[ItemCost]/100*14 or can I use the % input i.e. [ItemCost]*14%

Gareth
Click to expand...
Click to expand...
 
Top