totalling field data based on current record filter

[chanchito]

Good evening,

I have received some excellent help regarding a previous quandry I had,
and I have returned with yet another one.

I am trying to wrap my head around creating an unbound field on a form
that would display the total hours worked for the Project that is
attached to the current record being displayed in that form.

Meaning...

I have a table with a total_hours_worked field as well as a
project_name field. I have been able to create an unbound field on the
form that will tally all the hours in the total_hours_worked field, but
the difficulty arises when I add a new project_name into the mix. The
unbound field is basically just totalling all the total_hours_worked
records and displaying the number. What I would like it to do is only
display the add up the total_hours_worked records that match the
Project_name for the current record. So if I am looking at ProjectA
then the Total Hours to Date (the unbound field) will only add up the
total_hours_worked for records pertaining to ProjectA, and continue to
change based on whatever Project is being looked at.

Any help would be greatly appreciated as always

cheers
chanchito

 

[JK]

Cahnchito :-(

With due respect, This is *not* a new question You have already asked this
question, word to word!, got an answer, asked more and got an answer. There
is no need to re-post a question which is "in progress".

The least you can do is say that you are repeating a question because of
...... whatever ....

Use the "Watch" facility.

JK