Across Records

[seaDog]

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

[LiveOak]

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

[seaDog]

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