field definition problem/calculation problem?

[Wendryn]

I have two tables that come into this and I am not sure what I am doing wrong. In one table I have definitions of trainings, including required hours (field is ReqHours) for each training. In another I have trainings associated with specific people, including TrainingHours, which is the number of hours associated with that particular training for that person, and TotalHours, a summary field, which adds up the TrainingHours.

 

What I can't get to show up, and I'm not sure how to set up a field to make it work, is ReqHours - TotalHours. I have tried putting it in each of the tables and in the subtotal section of the report, but it seems to be using all of the data from everyone rather than just from that one person, and I have no idea what I am doing wrong. I can't get reasonable numbers. The other fields work fine, so clearly this is user error.

 

Any help would be greatly appreciated.

 

--Wendryn

[FileMakin' Tom]

You first need to set up a relationship between the person and the hours files. If John Doe is #37, then the posts of his hours would be made under that ID, tying only those hours to his name. Then a summary field, based on that relationship would total only the hours atributed to John Doe (Or whoever else's number matches the hours records).

 

Be well . . .

 

Tom

[Wendryn]

I have the staff table and the hours table connected, and the hours table is also connected to the training definition table. I have TotalHours, which adds up only the hours associated with a specific person - that works. What doesn't work is getting the hours from another table, ReqHours (which is the total number of hours required for that particular training) to subtract TotalHours. Does that explain it better?

 

Thank you for your help!

 

--Wendryn

[Wendryn]

OK, in addition - I figured out where the weird numbers are coming from. TotalHours adds up all the hours, but when put in a report with subtotals it only pulls up the number associated with the subtotal, which is what I need. The problem comes in when I try to get ReqHours to subtract the subtotal of TotalHours instead of the entire number.

 

I hope this is not all gibberish. I'm a bit frustrated.

 

Thank you!

 

--Wendryn