Syntax on Query Calculated Field

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

Guest

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!
 
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).
 
=?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])
 
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...
 
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...
 
Back
Top