SUMIF HELP!!!

[Guest]

Sample data:

Project_Year Owner_1_hrs Owner_2_hrs Owner_3_hrs
06 2 4
4
06 20 20
0
07 20 3
0
06 0 30
50

I have this data within a continuous form and a label that is currently
calculating the sum of the Owner_hrs per owner.

How could I write a sum if to sum owner_hrs by the year '06?

Thanks!!!

 

[Jeff Boyce]

Paula

I can't tell if you are trying to get a sum onto the form, or just looking
for a way to the the sum for a Project_Year? Have you looked into using
queries? Or the DSum() function?

Regards

Jeff Boyce
Microsoft Office/Access MVP