Re: using the IIF function in access
- From: "OfficeDev18 via AccessMonster.com" <u14095@uwe>
- Date: Tue, 31 Jan 2006 17:46:21 GMT
There really are no shortcuts. You need to say:
IIf(([entitydiscretedata]![velocityflag]>30,000) Or ([entitydiscretedata]!
[velocityflag]<-30,000), "
",[entitydiscretedata]![velocity])
A better way would be to say:
IIf(Abs([entitydiscretedata]![velocityflag])>30,000, "
",[entitydiscretedata]![velocity])
The Abs() function returns the absolute value of the ![velocityflag], and
will return a <blank> whether the flag is >30,000 or <-30,000.
Hope this helps.
Sam
Season wrote:
>i am trying to set a certain field to a blank vaule if another field is >than
>30,000 or >-30,000. i have set it up and it is working fine with changing
>the value to a blank if it is 0ver 30,000, but i am not sure how to work in
>the -30,000. this is what i have:
>
>IIf([entitydiscretedata]![velocityflag]>30,000, "
>",[entitydiscretedata]![velocity])
>
>how can i make this also use anything over -30,000 show up blank. this is
>kinda confusing with the negative in there and using >< signs. Well to me it
>is. Is is less than -30,000 or >-30,000. i am trying to flag values like
>-38345, -32466 etc.
--
Sam
Message posted via http://www.accessmonster.com
.
- Prev by Date: Re: Conditional test to combine multiple records
- Next by Date: Re: add selected records
- Previous by thread: Re: And Using a query to select data in one field compared to another
- Next by thread: How do I prevent PivotTable Query from Being Saved
- Index(es):
Relevant Pages
|
|
