expression which calculates GST at 7% before July 1 and 6% after?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Currently, I have GST calculated at [Fee]*.07
What would the expression look like to indicate
GST before July 1, 2006 is equal to Fee *.07 and after July 1, 2006 is equal
to Fee *.06.

If I just change the GST to Fee *.06 it changes all the invoices back to the
beginning of my business.
Please help
Thanks
 
Ken's suggestion will get you out of trouble for now, but you might like to
consider adding another field to your table to store the GST rate.

This will solve your problems in the longer term, e.g.:
- when they change the rate again;
- when they decide to make some items exempt;
- if your database is used in other places with a different rate.

After you add the new field to your table, you can use an Update query to
populate it with 0.07 for all the existing invoices.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Ken Snell (MVP) said:
[Fee]*IIf([DateFieldName]<#7/1/2006#,0.07,0.06)

--

Ken Snell
<MS ACCESS MVP>

hummingbird said:
Currently, I have GST calculated at [Fee]*.07
What would the expression look like to indicate
GST before July 1, 2006 is equal to Fee *.07 and after July 1, 2006 is
equal
to Fee *.06.

If I just change the GST to Fee *.06 it changes all the invoices back to
the
beginning of my business.
Please help
Thanks
Click to expand...
Click to expand...
 
I agree with Allen's design change suggestion.

--

Ken Snell
<MS ACCESS MVP>

Allen Browne said:
Ken's suggestion will get you out of trouble for now, but you might like
to consider adding another field to your table to store the GST rate.

This will solve your problems in the longer term, e.g.:
- when they change the rate again;
- when they decide to make some items exempt;
- if your database is used in other places with a different rate.

After you add the new field to your table, you can use an Update query to
populate it with 0.07 for all the existing invoices.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Ken Snell (MVP) said:
[Fee]*IIf([DateFieldName]<#7/1/2006#,0.07,0.06)

--

Ken Snell
<MS ACCESS MVP>

hummingbird said:
Currently, I have GST calculated at [Fee]*.07
What would the expression look like to indicate
GST before July 1, 2006 is equal to Fee *.07 and after July 1, 2006 is
equal
to Fee *.06.

If I just change the GST to Fee *.06 it changes all the invoices back to
the
beginning of my business.
Please help
Thanks
Click to expand...
Click to expand...
Click to expand...
 
Back
Top