Data question


E

Eric Brenner

Simple question.

I have a Inventory Database that I am making updates to. One of the
requirements is that they want to calculate a labor charge based on
our company's standard labor rate. Instead of hard-coding this into a
function, I would like to have this accessable to certain individuals
that have authority to change this. Should I store this value in a
table, a text file, somewhere else?

Your opinions are greatly appreciated!
Eric
 
T

Tony Toews

I have a Inventory Database that I am making updates to. One of the
requirements is that they want to calculate a labor charge based on
our company's standard labor rate. Instead of hard-coding this into a
function, I would like to have this accessable to certain individuals
that have authority to change this. Should I store this value in a
table, a text file, somewhere else?
You should store this in a table with a start and end date.

You will then either want to

1) have multiple records in this table so you can lookup the labour
charge rate as required.

2) store the labour rate with each transaction so you can retrieve the
proper rate in future years.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Question 2
Answer to book questions 0
Foxpro data to Access 97 1
Two questions about converting data to SPSS 1
MDE questions 4
Raid question 14
Question 7
Basic conversion question 2

Top