Using Acess Expression Builder 1

[jb61264]

I'm trying to use expression builder as follows:

=Sum([HOURS])

This works just fine for my [HOURS] column of data but I need to add another element to this expression and I can't quite figure out how to do it. Here is what I am trying:

=Sum([HOURS] & [F or D]="B")

What I need this expression to do is to give me the sum of the [HOURS] column on ly when my [F or D] column is equal to B...so it's like I need to include a "where" clause but it doesn't appear that Access expression builder supports this.

Does anyone know how I can accomplish what I'm trying to do with expression builder in Access?

Thanks is advance

 

[PHV]

=Sum(IIf([F]="B" Or [D]="B",[HOURS],0))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244