sub-totals

[SueBK]

I'm not sure I've set up my tables right, which may answer my question.

I'm setting up a personal database (have rocks in my head) to track a bunch of home renovation projects. So far I have two tables - one for projects and one linked on the project ID for separate tasks.

In tblProjects I have fields for total project cost and time. Each task in tblTasks has a time and cost component. I would like the tblProject fields to be based on the totals from tblTasks.

I created a "grouped" query for cost and time, but the table doesn't want to let me use that as a look up.

How do I get the totals across from tblTasks to tblProjects?

 

[plog]

You don't. You shouldn't store data that is based on other data that you store. What you need to do is create a query to total up the values in tblTasks and run that query when you need to use the totals.