Data question

Discussion in 'Access Conversion' started by Eric Brenner, Oct 21, 2011.

  1. Eric Brenner

    Eric Brenner Guest

    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
     
    Eric Brenner, Oct 21, 2011
    #1
    1. Advertisements

  2. Eric Brenner

    Tony Toews Guest

    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/
     
    Tony Toews, Oct 23, 2011
    #2
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.