What does this excel formula translate to in Access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do i convert it to an access query expression?

if(and([ DmdVar] >= 80, [Invstdday] <=15),"Green","Red")

i know that if = IIF in access... but the rest aren't working. I'll get a #
error
 
lay said:
How do i convert it to an access query expression?

if(and([ DmdVar] >= 80, [Invstdday] <=15),"Green","Red")

i know that if = IIF in access... but the rest aren't working. I'll get a #
error
Click to expand...


IIf(DmdVar >= 80m And Invstdday <=15, "Green", "Red")
 
i tried that before, and i tried it again, and it still returns #error in
Database view

Jeff L said:
iif([DmdVar] >= 80 And [Invstdday] <=15,"Green", "Red")

Hope that helps!

How do i convert it to an access query expression?

if(and([ DmdVar] >= 80, [Invstdday] <=15),"Green","Red")

i know that if = IIF in access... but the rest aren't working. I'll get a #
error
Click to expand...
Click to expand...
 
ok, i changed the properties for dmdvar and invstddays to "number", and now,
it returns "Red", but it still gives a #error for "Green"

Jeff L said:
iif([DmdVar] >= 80 And [Invstdday] <=15,"Green", "Red")

Hope that helps!

How do i convert it to an access query expression?

if(and([ DmdVar] >= 80, [Invstdday] <=15),"Green","Red")

i know that if = IIF in access... but the rest aren't working. I'll get a #
error
Click to expand...
Click to expand...
 
never mind...silly me changed the wrong field to "number"...it works now.
Thanks for all your help!!!

lay said:
ok, i changed the properties for dmdvar and invstddays to "number", and now,
it returns "Red", but it still gives a #error for "Green"

Jeff L said:
iif([DmdVar] >= 80 And [Invstdday] <=15,"Green", "Red")

Hope that helps!

How do i convert it to an access query expression?

if(and([ DmdVar] >= 80, [Invstdday] <=15),"Green","Red")

i know that if = IIF in access... but the rest aren't working. I'll get a #
error
Click to expand...
Click to expand...
Click to expand...
 
Back
Top