Total hours per month - new user

[kipper]

I have a database where users enter their monthly hours on various projects. I then want to transfer this information to a time sheet database where employees monthly hours are summarised by category, e.g. admin hours, project hours etc. It works fine in the original database and lists total project hours per month. But when I try to include that in the time sheet database it only shows the project hours for January, regardless of which month is being summarised. (The other hours are entered directly into the timesheet file so they work ok) I've set up a relationship between the two files using the Employee ID field. I'm using the following calculations:

Total project hours by month: Sum( SELF_EmpID with Month::Total Hours )

EmpID with month: Employee ID & "-" & month1

month1: standard text field with value list for months

I'm stuck now and can't work out why it is not working. I need a fresh (and more knowledgeable) eye on it! Hope someone can help.

[QuinTech]

Hi kipper, could you post a clone of your file here? There are several reasons why this might not be working. My first guess, since you say the calc works only for January, is that your relationship isn't set up right, and is thus only grabbing the first record from the related file (which makes sense if it's January). The sample code you gave us doesn't look wrong, but without context it's tough to determine.

Jerry

[kipper]

Hi Jerry

I've attached all the relevant files I could think of. Thanks!

zip.zip

[-Queue-]

Your project ts relationship is related only by Employee ID. No matter what you change the month to, the relationship doesn't change. So it's always going to show data from the first related record for the selected employee. You need to relate the EmpId with month fields.