this or this

  • Thread starter Thread starter jlute
  • Start date Start date
J

jlute

I'm trying to get:
If [Type] = "BTGL" or "BTPL" Then
[ODHeight]*[tblUOMLength_5].[inConvFactor]+0.125

otherwise
[ODHeight]*[tblUOMLength_5].[inConvFactor]

I've tried this:
ODHCap: IIf([Type]="BTGL" & "BTPL",[ODHeight]*[tblUOMLength_5].
[inConvFactor]+0.125,[ODHeight]*[tblUOMLength_5].[inConvFactor])

No good.

I'm sure I'm approaching this all wrong. Can anyone point out the
error of my ways?

Thanks!
 
Try this ---
ODHCap: IIf([Type] = "BTGL" or [Type] = "BTPL",
([ODHeight]*[tblUOMLength_5].[inConvFactor]+0.125),
([ODHeight]*[tblUOMLength_5].[inConvFactor])
 
I'm trying to get:
If [Type] = "BTGL" or "BTPL" Then
[ODHeight]*[tblUOMLength_5].[inConvFactor]+0.125

otherwise
[ODHeight]*[tblUOMLength_5].[inConvFactor]

I've tried this:
ODHCap: IIf([Type]="BTGL" & "BTPL",[ODHeight]*[tblUOMLength_5].
[inConvFactor]+0.125,[ODHeight]*[tblUOMLength_5].[inConvFactor])

No good.

I'm sure I'm approaching this all wrong. Can anyone point out the
error of my ways?

Thanks!
Click to expand...

ODHCap: IIf([Type]="BTGL" OR [Type] = "BTPL",
[ODHeight]*[tblUOMLength_5].[inConvFactor]+0.125,
[ODHeight]*[tblUOMLength_5].[inConvFactor])
 
Or:

ODHCap: [ODHeight]*[tblUOMLength_5].[inConvFactor]+
IIf([Type] = IN("BTGL", "BTPL") , 0.125, 0)

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.



KARL DEWEY said:
Try this ---
ODHCap: IIf([Type] = "BTGL" or [Type] = "BTPL",
([ODHeight]*[tblUOMLength_5].[inConvFactor]+0.125),
([ODHeight]*[tblUOMLength_5].[inConvFactor])

--
KARL DEWEY
Build a little - Test a little


[email protected] said:
I'm trying to get:
If [Type] = "BTGL" or "BTPL" Then
[ODHeight]*[tblUOMLength_5].[inConvFactor]+0.125

otherwise
[ODHeight]*[tblUOMLength_5].[inConvFactor]

I've tried this:
ODHCap: IIf([Type]="BTGL" & "BTPL",[ODHeight]*[tblUOMLength_5].
[inConvFactor]+0.125,[ODHeight]*[tblUOMLength_5].[inConvFactor])

No good.

I'm sure I'm approaching this all wrong. Can anyone point out the
error of my ways?

Thanks!
Click to expand...
Click to expand...
 
Thanks, everyone! I didn't realize that I needed to reference [Type]
twice.

Dale, I just recently became familiarized with IN via John Spencer.

FYI I tried your usggestion but it has a syntax error. Of course I
"cleaned" it up to remove spaces, etc. It seems that IN is the
culprit.

Or:

ODHCap: [ODHeight]*[tblUOMLength_5].[inConvFactor]+
              IIf([Type] = IN("BTGL", "BTPL") , 0.125, 0)

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.



KARL DEWEY said:
Try this ---
   ODHCap: IIf([Type] = "BTGL" or [Type] = "BTPL",
([ODHeight]*[tblUOMLength_5].[inConvFactor]+0.125),
([ODHeight]*[tblUOMLength_5].[inConvFactor])
Click to expand...
I'm trying to get:
If [Type] = "BTGL" or "BTPL" Then
[ODHeight]*[tblUOMLength_5].[inConvFactor]+0.125
otherwise
[ODHeight]*[tblUOMLength_5].[inConvFactor]
I've tried this:
ODHCap: IIf([Type]="BTGL" & "BTPL",[ODHeight]*[tblUOMLength_5].
[inConvFactor]+0.125,[ODHeight]*[tblUOMLength_5].[inConvFactor])
No good.
I'm sure I'm approaching this all wrong. Can anyone point out the
error of my ways?
Thanks!- Hide quoted text -
Click to expand...
Click to expand...

- Show quoted text -
Click to expand...
 
Oops, that should have been:

ODHCap: [ODHeight]*[tblUOMLength_5].[inConvFactor]+IIf([Type] IN("BTGL",
"BTPL") , 0.125, 0)

I added an = sign where I shouldn't have, right before the IN clause.

Dale

Thanks, everyone! I didn't realize that I needed to reference [Type]
twice.

Dale, I just recently became familiarized with IN via John Spencer.

FYI I tried your usggestion but it has a syntax error. Of course I
"cleaned" it up to remove spaces, etc. It seems that IN is the
culprit.

Or:

ODHCap: [ODHeight]*[tblUOMLength_5].[inConvFactor]+
IIf([Type] = IN("BTGL", "BTPL") , 0.125, 0)

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.



KARL DEWEY said:
Try this ---
ODHCap: IIf([Type] = "BTGL" or [Type] = "BTPL",
([ODHeight]*[tblUOMLength_5].[inConvFactor]+0.125),
([ODHeight]*[tblUOMLength_5].[inConvFactor])
Click to expand...
I'm trying to get:
If [Type] = "BTGL" or "BTPL" Then
[ODHeight]*[tblUOMLength_5].[inConvFactor]+0.125
otherwise
[ODHeight]*[tblUOMLength_5].[inConvFactor]
I've tried this:
ODHCap: IIf([Type]="BTGL" & "BTPL",[ODHeight]*[tblUOMLength_5].
[inConvFactor]+0.125,[ODHeight]*[tblUOMLength_5].[inConvFactor])
No good.
I'm sure I'm approaching this all wrong. Can anyone point out the
error of my ways?
Thanks!- Hide quoted text -
Click to expand...
Click to expand...

- Show quoted text -
Click to expand...
 

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

Similar Threads

How do I stop automatic spaces after commas and periods? 1
Paragraph indent marker increments 1
Access Query problem 1
Excel fromula: Adding numbers from list to achieve a target 4
Criteria to return all records if selection from form is null 3
Access My Expression Contains Wrong number of arguments 0
IIF statement in query criteria, help! 2
Complicated Calculated Field Logic 0

Back
Top