Forms Expression Builder

[blubeacon]

Hello,

I have a form that asks for 3 fields: Project, Consultant, Hours. How do
write the expression to add the hours for each of the consultants that has bee
assigned to a project? In other words, if consultant a has been assigned
projects, how can I add those hours for only the projects that were assigned t
him? I'm trying to show the number of hours spent on projects during the cours
of a year for each consultant. I've tried using SUM and IIF combinations bu
none of them have worked.

Thanks for the help.

 

[Tom van Stiphout]

On Mon, 22 Feb 2010 14:58:09 -0600, blubeacon

You could use the DSum function. See help file for details.

-Tom.
Microsoft Access MVP