• 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?
0
rdperkins
Asked:
rdperkins
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).

Regards,

Patrick
0
 
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.
0
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