Sales tax

[Guest]

How do I handle sales tax and other rarely changed (semi constant variables!
) variables. EG In my recipe database for a costing report Im wanting to use
a Wage rate that applies to all recipes. I want to store this Pay rate in one
place so I can change it at sometime and ALL the recipes will recalculate the
labour cost from this. Please tell me its simple! Seems to me its very much
like a sales tax thing.

 

[Ed Warren]

build a vba function to return the wage Rate

e.g.
Public function getWageRate() as double
WageRate = 5.250
end function

Then when you need to calculate the cost in a query, form or report

=[variable]*getWageRate()

When you need to change the rate just edit the value entered in the module.

Ed Warren

 

[DebbieG]

You could create a table tblWageRate with a field called curWageRate. Then

Use this table in queries for your forms or reports and then

=[YourField] * curWageRate

HTH,
Debbie


| How do I handle sales tax and other rarely changed (semi constant variables!
| ) variables. EG In my recipe database for a costing report Im wanting to use
| a Wage rate that applies to all recipes. I want to store this Pay rate in one
| place so I can change it at sometime and ALL the recipes will recalculate the
| labour cost from this. Please tell me its simple! Seems to me its very much
| like a sales tax thing.
| --
| ericb