My head is starting to spin

[eww]

I feel like I might be going a round about way of getting what I want.



An employee enters into a time sheet form hours that they work on a project. There can be multiple occurances of this as they work on the same project day to day. I then have a query called [qryDetailedHours] that sums the hours for each job they work on.

In a different form they are logging what they are doing on each project, and this includes the weight of what they have worked on / detailed (industrial work). I have another query called [qryDetailedWeight] that sums up this weight.

What I'm trying to get, my end goal, is "Tons/Hr". The weights however are in lbs. I want this to show up on the Project Info form, and I've gotten both the Hours and Weights to show up on this form by way of subforms. However when I try to slap tons/hr on there from a query that I've made it shows the same number for every single project.

The query uses the Job Number from the Project Info table related to the information in my two queries and then I have an expression for Tons: [qryDetailedWeight].[SumOfWeight]/2000 and TonsPerHour: [Tons]/[qryDetailedHours].[SumOfHours]

In the query all the job numbers are showing up with the right tons and tons/hr but in the Project Info Form things just don't connect.

[eww]

well I got what I want but definitely not using a query. I'm still learning Access and all what to use where and when in the vba editor. I've got the Weight and Hours both in subforms so I figured out how to use that data to calculate the tons/hr in the vba.

Dim Tons
Tons = Me.sfrmDetailedWeight.Form.SumOfWeight / 2000
Me.TonsPerHour.Value = Tons / Me.sfrmDetailedHours.Form.SumOfHours

I'm sure there's still plenty to go wrong with my simple solution, but that's why it's a work in progress.