[AccessD] A2003: Calculating tax amounts

Hi Gustav

Yes the tax rate in Oz it is still 10 percent - We have been very lucky. We had
a conservative government introduce it here a bit under 10 years ago. We have
just voted in a socialist government. They have kept the issue of raising the
tax rate off the radar - but who knows. 10 percent (despite me whinging about
it) seems kinda lean when looking at other GST and VAT nations

I had a feeling it was you who provided the solution in the first place
Didn't want to mention names - In case I forgot the correct person. I never
remember to use the archives - I really need to get into the habit
Many thanks for pursuing this - Gustav - Legend be thy name :-)

Many many thanks
 
Darren
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Friday, 29 August 2008 7:26 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] A2003: Calculating tax amounts

Hi Darren

Still at 10%?

  http://databaseadvisors.com/pipermail/accessd/2005-January/030788.html 

/gustav


>>> darren at activebilling.com.au 29-08-2008 04:07 >>>
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