Syntax on Query Calculated Field

D

Derek Wittman

Check:iif(([slot id] is Like "10 1*" Or Like "10 2*" Or Like "10 36*"),"Not
Front End Regional", [tblMPOS-Class].[Tote Groupings])

Any idea where I'm going wrong with this?

Thanks!
 
J

Jerry Baker

Derek said:
Check:iif(([slot id] is Like "10 1*" Or Like "10 2*" Or Like "10 36*"),"Not
Front End Regional", [tblMPOS-Class].[Tote Groupings])

Any idea where I'm going wrong with this?
Click to expand...

If it's not a typo, you either need to add "is like" before each test,
or remove the "is" from the first (I don't remember which).
 
M

Michael Gramelspacher

=?Utf-8?B? said:
Check:iif(([slot id] is Like "10 1*" Or Like "10 2*" Or Like "10 36*"),"Not
Front End Regional", [tblMPOS-Class].[Tote Groupings])

Any idea where I'm going wrong with this?

Thanks!
Click to expand...
Why not go to SQL View and copy the entire SQL statement and paste it into
the newsgroup message?

might work, might not:

Check:iif(([slot_id] Like '10 1*') Or ([slot_id] Like '10 2*') Or
([slot_id] Like '10 36*'),'Not
Front End Regional', [tblMPOS-Class].[Tote Groupings])
 
D

Derek Wittman

Problem I have is that I cannot get the calculated field even in the query TO
put it to SQL view. Sorry, Michael.

Michael Gramelspacher said:
=?Utf-8?B? said:
Check:iif(([slot id] is Like "10 1*" Or Like "10 2*" Or Like "10 36*"),"Not
Front End Regional", [tblMPOS-Class].[Tote Groupings])

Any idea where I'm going wrong with this?

Thanks!
Click to expand...
Why not go to SQL View and copy the entire SQL statement and paste it into
the newsgroup message?

might work, might not:

Check:iif(([slot_id] Like '10 1*') Or ([slot_id] Like '10 2*') Or
([slot_id] Like '10 36*'),'Not
Front End Regional', [tblMPOS-Class].[Tote Groupings])
Click to expand...
 
D

Derek Wittman

I was able to figure out with what you gave me. This was more than
sufficient. Thank you!


Michael Gramelspacher said:
=?Utf-8?B? said:
Check:iif(([slot id] is Like "10 1*" Or Like "10 2*" Or Like "10 36*"),"Not
Front End Regional", [tblMPOS-Class].[Tote Groupings])

Any idea where I'm going wrong with this?

Thanks!
Click to expand...
Why not go to SQL View and copy the entire SQL statement and paste it into
the newsgroup message?

might work, might not:

Check:iif(([slot_id] Like '10 1*') Or ([slot_id] Like '10 2*') Or
([slot_id] Like '10 36*'),'Not
Front End Regional', [tblMPOS-Class].[Tote Groupings])
Click to expand...
 
Top