• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 180
  • Last Modified:

Query problems recreating an Access 2007 query in an Access 2007 ADP

Using SQL Server 2005 from an ADP front-end. I am trying to recreate an Access query in the ADP. I'm having trouble creating a field based on an expression such as NewField:if(x,y,z). Is this possible? Also, can I use a form field reference as a criteria expression in the new query?
1 Solution
Patrick MatthewsCommented:
Hello rdperkins,

Please post the Jet SQL you used in Access.  Sounds like it needs to be redone in T-SQL for
SQL Server (in this particular case, looks like Jet's IIf() becomes a CASE structure).


Vitor MontalvãoMSSQL Senior EngineerCommented:
Seems to me that MS Access query is using VB functions, so you can't pass it directly to SQL Server.
Reference to forms fields aren't allowed in SQL Server.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now