subform and totals

E

Eric Blitzer

Window 2000
Office 2000

Main form = A-Main
Subform = A-Main-Sub - continuous form
example of data on subform
RDate time-in LunchOut LunchBack EndTime
7/1/04 7:30 AM 12:00 PM 1:00 PM 4:30 PM
7/2/04 7:30 AM 12:00 PM 1:00 PM 4:30 PM
7/3/04 7:30 AM 12:00 PM 1:00 PM 4:30 PM
7/4/04 7:30 AM 12:00 PM 1:00 PM 4:30 PM
7/5/04 7:30 AM 12:00 PM 1:00 PM 4:30 PM
7/8/04 7:30 AM 12:00 PM 1:00 PM 4:30 PM
7/9/04 7:30 AM 12:00 PM 1:00 PM 4:30 PM
7/10/04 7:30 AM 12:00 PM 1:00 PM 4:30 PM
7/11/04 7:30 AM 12:00 PM 1:00 PM 4:30 PM
7/12/04 7:30 AM 12:00 PM 1:00 PM 4:30 PM

I want to add a total to the right for each line. Then I
want to total(it could be on the main form for each
week(first 5 entries then the second 5 entries). anyone
know how I can accomplish both of these?

Thanks

Eric Blitzer
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding rota 0
Min, Max 3
How to build subquery on aggregate query 0
INDEX MATCH SMALL 13
Total Minutes Worked Within IVR Timing 1
Calculating Meal Period Violations in Access 2
Occasional meter readings chart 0
5 minute time increments 2

Top