ACCESS 2003 IFF Statement

[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])))

 

[Klatuu]

Where are you trying to use this code?

 

[tony]

VISITA IL MIO SITO WWW.ZAJON.IT
VISIT MY WEBSITE HELO?

 

[Tarni]

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