[AccessD] A2003: Calculating tax amounts

David - perfect - that was it

Many many thanks
 
Darren
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David Emerson
Sent: Friday, 29 August 2008 12:17 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] A2003: Calculating tax amounts

Darren,

Try Amt / (1 + Tax Rate).

Eg $112.5 / (1 + 0.125) = $100  (12.5% is the NZ GST Rate)

Regards

David

At 29/08/2008, you wrote:
>Hi team
>
>I have asked this years ago and can't find the answer nor the dB I 
>performed it
>on :-(
>
>I need to know the inclusive and exclusive tax components of a given amount
>
>Here in OZ the tax rate on goods and services is 10 percent
>
>So if I have a $150 tax Exclusive amount then the Tax inclusive 
>amount is $165 -
>Simple
>
>And whilst ever the tax rate is 10 percent I can divide by one 11th to get the
>Tax Exclusive amount - no prob
>
>But I had a formula from some lovely person on this list that 
>allowed this to be
>dynamically calculated regardless of the tax rate
>
>Any clues?
>
>Many thanks in advance
>
>Darren
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com