locked
Expense database design help needed RRS feed

  • Question

  • Hi Community,
    I am working on a database for about a week. This database is of a company which deals with creation of auto parts. Main needs of database are to record the date and project wise expenses which are (daily wages of labor, cost of machinery, and cost of material used materials are taken from different vendors).
    And then i need to create a report which will show all expenses for a particular project date wise. I was stuck with the design of input screen then i some how sorted out the problem using subforms.
    but i don't find the design appropriate because it doesn't let me make a report. Kindly guide how am i supposed to make this database.
    Note there can be multiple date entries for a project and each date contains multiple expenses under each head.
    I need your help as soon as possible kindly guide me with the design of database with which i could be able to make easy data entry forms and expense reports as well.
    Regards
    Hira
    Wednesday, February 17, 2016 3:25 PM

Answers

  • Your report would need sub reports just like your form has. There are probably a number of templates that would give you an idea as to how to proceed.

    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    Wednesday, February 17, 2016 4:04 PM

All replies

  • Hi Community,
    I am working on a database for about a week. This database is of a company which deals with creation of auto parts. Main needs of database are to record the date and project wise expenses which are (daily wages of labor, cost of machinery, and cost of material used materials are taken from different vendors).
    And then i need to create a report which will show all expenses for a particular project date wise. I was stuck with the design of input screen then i some how sorted out the problem using subforms.
    but i don't find the design appropriate because it doesn't let me make a report. Kindly guide how am i supposed to make this database.
    Note there can be multiple date entries for a project and each date contains multiple expenses under each head.
    I need your help as soon as possible kindly guide me with the design of database with which i could be able to make easy data entry forms and expense reports as well.
    Regards
    Hira
    Wednesday, February 17, 2016 3:09 PM
  • Your report would need sub reports just like your form has. There are probably a number of templates that would give you an idea as to how to proceed.

    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    Wednesday, February 17, 2016 4:04 PM