seaDog Posted November 6, 2002 Share Posted November 6, 2002 My first post and already a question ! I have a simple db that logs times on a job, each week has a record and a repeating field for each day, with the number of hours worked for that day. I need to display 3 day totals, so for example the 3 day total on the first day of the week (also the first day of the record) would need to include the number of hours from day 6 & 7 of the previous record, if you see what I mean. How's the best way to achieve this without scripting, just using fields, any ideas would be gratefully received. And sorry once again for asking a question on my first post. Thanks seaDog Link to comment Share on other sites More sharing options...
LiveOak Posted November 6, 2002 Share Posted November 6, 2002 The single best way to deal with time records by day is to use a second related file in which each record is a day and use relationships to pull up records to be totaled. The use of repeating fields will cause problems down the road. -bd Link to comment Share on other sites More sharing options...
seaDog Posted November 6, 2002 Author Share Posted November 6, 2002 I see what you are saying, but I wanted to avoid clicking on a new record for every day, when the users enter their data a week at a time. thanks seaDog Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7976 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now