ACCESS 2003 IFF Statement


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

Advertisements

Ad

Advertisements

Joined
Apr 12, 2016
Messages
1
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top