Access Formula Help With VAT

Atomic · 30 Dec 2009 at 21:00

Hello, I have simple database with the following formula providing a VAT calculation:

=([vatrecovery]+[vatstorage]+[vatextra])*IIf([date out]>#30/11/2008#,0.15,0.175)

That formula accounts for the 15% VAT rate after that date and puts everything before that as 17.5%

However, I need to amend the formula to account for the VAT rate after 1st Jan '10 so that 17.5% is applicable if date out is greater than 31st Dec '10.

Any help would be appreciated

NathanT · 30 Dec 2009 at 21:29

Might not look pretty, but could you just not use an AND clause in there?

=([vatrecovery]+[vatstorage]+[vatextra])*IIf([date out]>#30/11/2008# AND [date out]<#31/12/2009#,0.15,0.175)

I'm sure there would be a more pleasing to look at way of doing it, but this could point you in the correct direction

NathanT · 30 Dec 2009 at 21:36

Or you could use the between condition.

=([vatrecovery]+[vatstorage]+[vatextra])*IIf([date out] BETWEEN #30/11/2008# AND #31/12/2009#,0.15,0.175)

Cant check the validity of either statement I'm afraid as I dont have access on my laptop

Atomic · 30 Dec 2009 at 21:46

Thanks. The BETWEEN code is what I need. So simple.

Thanks for your help.