Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2011

    Unanswered: Can someone answer a question for a novice

    I have in excel
    Labor Material Overheads 12-Jan 12-Feb 12-Mar
    0.6 0.15 0.25 10000 10000 10000

    I need to create in Access a table or query that would split the cost for each month like the following

    Labor Material Overheads 12 Jan Labor 12 Jan MAT 12 Jan OH
    0.6 0.15 0.25 6000 1500 2500

    My cost will range over many months of a project so I will need Access to recognize the months in my excel table. Does anyone know of a template that is out there or the type of query I should do.


  2. #2
    Join Date
    Mar 2009
    Provided Answers: 14
    As a general rule (one among many in database normalization, see for instance: Fundamentals of Relational Database Design -- ) you don't store values that can be computed. Either you store the amounts and the ratios for each area (Labor, Material, Overheads) and you compute the totals, or you store the totals and the ratios and you compute the amounts for each area.

    Infos such as dates should also be stored in their basic format (Date/Time data type in this case), the way the user interface displays the data can be later determined by a format applied in the form or the report.
    Have a nice day!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts