Forms

[GregFish]

I am creating a time sheet, it has only one table, when i create the form for the user input, my calculations from the calculated fields do not show up in my main table all other information input is passed to the table. i have tried multiple tables and have rebuilt my database several times can someone help me find out why.

 

[KyleB]

I believe that generally speaking you don't want to store calculated values in a table. It will increase the size of your database exponentially as time goes by, and is unnecessary. If it's calculated once, then it can be calculated later. All you really want to store is the raw base data that the calculations are made from, then you create a query that does the calculations and a report that shows those results anytime you're wanting a report of that data.

Kyle

Sorry if that might be a bit vague, I'm more used to asking questions here, or searching the existing posts, than I am with answering someone else.

 

[daveUK]

Greg

I'm presuming that you are holding the amount of hours worked by each employee each day/week/month. If so you will need 2 tables. One to hold the employee details and one to hold the hours worked by each employee.

You will also need 2 forms. The main form will hold the employee details and the subform will show the hours worked.

HTH