• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 432
  • Last Modified:

Running total on main form with table as source object of subform

I would like to be able to have a running sum on a main form from a sub form that is based on a table source object. This is an access 2003 database. I am currently able to provide them the total after they have saved the records. I have tried both Dsum and Dlookup to get this to work but it fails.
0
smolbeck367
Asked:
smolbeck367
  • 2
  • 2
1 Solution
 
peter57rCommented:
I'm not really clear what you are trying to do as you say that  ' I am currently able to provide them the total after they have saved the records.'

How else do you expect to be able to do it?

Assuming you are using bound forms, then as you move from main form to subform you automatically save the main form record and as you move from subform record to subform record each record is saved.
0
 
smolbeck367Author Commented:
Hi Peter57r, while they are entering their time for the day, I would like it to sum on the main form as they go. Once they hit save the daily time, the hours they have entered do appear. This is a time tracking tool that we have developed internally. We can either enter hours by the day for the entire week. When the user selects the day they want to enter time for - I would like the hours as they enter them to be a running sum on the main form. The hours are entered into a sub form with a table as a record source. In addition, this is a form with tab control. It is the after part that is the problem. The users would like to see the totals as they go.I hope that is more clear.  Thanks for your time.
0
 
peter57rCommented:
Sorry but it's still not really clear to me how this works.
Can you post a sample db or if not then images of design view and form view of your form.
0
 
smolbeck367Author Commented:
I was able to provide them a work around to this issue.  I think I will close it it for now. If I have to find another way I will repost. Thanks for taking the time.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now