if [combobox]=n then [expr1]=0

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that pulls from a query work that was completed for a given
day. The query also adds a dollar value to this. In the report there is a
field, [COMPLETE] that is either "Y" or "N". Is there code or another way
that I can have [Expr1] - [qty]*[price] equal to $0.00 if [COMPLETE] is equal
to "N"?

Thanks
 
you can set [Expr1] - [qty]*[price] as [Total_Price]

IIf([complete] = "N",[Total_Price] = $0.00, [Expr1]-[qty]*[price])

You didn't explain your issue very well, so it's kind of hard to figure out
what you need here. Hope that helped.
 
Back
Top