Re: Invalid SQL Statement

Bob,

Thank you. I'm sure that's it (IIF instead of IFF). I had just added
the IFF/IIF to this existing SQL statement. Sometimes, all it takes is
another set of eyes. Thanks, also, for reformatting the statement.

Thank you, again.

Regards,
SueB

*** Sent via Developersdex http://www.developersdex.com ***
.

Relevant Pages

  • Re: Order By
    ... I'm looking for direct translation of Access' IIF which used to work ... >> I have PartialNumber field in a table which contains values like ... >> I need to sort these values in SQL statement in descending order and get ...
    (microsoft.public.vb.general.discussion)
  • Re: Order By
    ... I'm looking for direct translation of Access' IIF which used to work ... >> I have PartialNumber field in a table which contains values like ... >> I need to sort these values in SQL statement in descending order and get ...
    (microsoft.public.sqlserver.programming)
  • Re: Order By
    ... I'm looking for direct translation of Access' IIF which used to work ... >> I have PartialNumber field in a table which contains values like ... >> I need to sort these values in SQL statement in descending order and get ...
    (microsoft.public.vb.database)
  • Re: Order By
    ... I'm looking for direct translation of Access' IIF which used to work ... >> I have PartialNumber field in a table which contains values like ... >> I need to sort these values in SQL statement in descending order and get ...
    (microsoft.public.vb.database.ado)
  • Re: Order By
    ... I'm looking for direct translation of Access' IIF which used to work ... >> I have PartialNumber field in a table which contains values like ... >> I need to sort these values in SQL statement in descending order and get ...
    (microsoft.public.vb.database.dao)