If's

If's

Post by Gary » Thu, 19 Feb 2004 01:08:10


Is it possible to use a similar command as the one below,
but to create more than 2 out comes.

=IIf(([Card Order Quantity]<51),"","")

I need to have about 5 out comes, depending on how many
cards are ordered.

(ie. 0-50 cards = ... 51-100 Cards = ... 101-500
Cards = and so on.)
Reagrds - Gary
 
 
 

If's

Post by Gerald Sta » Thu, 19 Feb 2004 01:35:20

Try replacing the false part of the IIf (in your example
"") with another IIf statement and so on.

Hope That Helps
Gerald Stanley MCSD >>-----Original Message----- >>Is it possible to use a similar command as the one below, >>but to create more than 2 out comes. >> >>=IIf(([Card Order Quantity<<51),"","">
>I need to have about 5 out comes, depending on how many>
>cards are ordered>
>(ie. 0-50 cards = ... 51-100 Cards = ... 101-5>0
>Cards = and so o>.)
>Reagrds - >ary> >.

 
 
 

If's

Post by Arvin Meye » Thu, 19 Feb 2004 01:50:39

You can add multiple nested IIf() statements:

IIf([Card Order Quantity]<61),"", IIf(([Card Order
Quantity<<51),"",""))

But it's far easier to do it in code with a Select Case statement:

Select Case Me.[Card Order Quantity]

Ca<e <51
Me.ControlName =

C<se <61
Me.ControlName =

<ase <71
Me.ControlName =

Case Else

End Select
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.yqcomputer.com/
http://www.yqcomputer.com/



Is it possible to use a similar command as the one below,
but to create more than 2 out comes.

=IIf(([Card Order Qua<tity]<51),"","")

I need to have about 5 out comes, depending on how many
cards are ordered.

(ie. 0-50 cards = ... 51-100 Cards = ... 101-500
Cards = and so on.)
Reagrds - Gary





---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system ( http://www.yqcomputer.com/ ).
Version: 6.0.587 / Virus Database: 371 - Release Date: 2/12/2004
 
 
 

If's

Post by Gary » Thu, 19 Feb 2004 02:04:34

Thanks for that - I understand the 1st way, but not sure
where to insert the 2nd way that you stated.

BUT, is it possible to do a similar thing with a new
table, so that if prices change I can make a new form to
up date them, rather than digging into the programming
side?

Many thanks - Gary
>But it's far easier to do it in code with a Select Case
statement>
>Select Case Me.[Card Order Quantity>
> Ca<e <5>
> Me.ControlName = >1 >>
> Ca<e <>1
> Me.ControlName =>> >
> Case >71
> Me.ControlName > gt;
>
> Case >ls>
>
>End Se>ect
>Arvin Meyer, MCP,>MVP
>Microsoft Ac>ess
>Free Access downlo>ds:
> http://www.yqcomputer.com/ >com
> http://www.yqcomputer.com/ ;es>
>
>"G<ry" < XXXX@XXXXX.COM >t.com> wrote in
mes>age

>Is it possible to use a similar command as the one be>ow,
>but to create more than 2 out co>es>
>
>=IIf(([Card Order Quan<ity]<51),"">"gt;")
>
>I need to have about 5 out comes, depending on ho> many
>cards are or>er>d.
>
>(ie. 0-50 cards = ... 51-100 Cards = ...>101-500
>Cards = an> so on.)
>Reagr>s > G>ry> >> >> >
>> >
>---
>Outgoing mail is certified Vi>us Free.
>Checked by AVG anti-virus system
( http://www.yqcomputer.com/ >ft.com).
>Version: 6.0.587 / Virus Database: 371 - Release Date: