Access 2003:percentage calculations

  • Thread starter Thread starter mcnaugg
  • Start date Start date
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
 
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
'====================================================
 
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...
 
Back
Top