calculation possibly in expression builder

[Matsta]

In access repots I want Field A to populate with Field b*Field c if field d = yes and Field e = yes. And If field D and Field E are not yes I would like to see zero dollars.
Example below:


Field B 50
Field C $1.00
Field D YES
Field E YES


Result I need:
Field A $50.00

 

[jebry]

Hi!

Try this:

=IIf(FieldD = "Yes" And FieldE = "Yes", FieldB*FieldC, 0)

This assumes that fieldD & E are text fields. Format the text box to display currency.

hth


Jeff Bridgham
bridgham@purdue.edu

 

[hneal98]

try this in field A:


=iif([D] = "Yes" and [E] = "Yes", [A]=*[C],[A]=0)

 

[THWatson]

Matsta
Will this work for Field A?

=IIf(([Field D]= Yes And [Field E]= Yes),[Field B]*[Field C],"$0.00&quot

Tom

 

[Matsta]

Thank you so much that worked perfect!!