ACCESS 2003 IFF Statement

  • Thread starter Thread starter LISAEON
  • Start date Start date
L

LISAEON

Buys and Sell Price is a positive value. I want to create an If Statement
that format the Buy Price as a negative value. I tried the following
expression, but it returned only positive Sell prices:

((CTSUSER_PHYDETAIL.PRICE)=IIf([CTSUSER_DEALHEADER.BUYORSELL]="B",(-1*[CTSUSER_PHYDETAIL.PRICE]),(1*[CTSUSER_PHYDETAIL.PRICE])))
 
Status: IIf([Dailyentry Query.Absent]="[Leaveapply.Leavefrom]","OnLeave","Absent")

am using this query for comparing absent date and leave date in my access database to find out onleave or absent bur its shows #error
Pls help
 
Back
Top