SQL Statment

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dib - 28 Jun 2004 16:28 GMT

Hi,
I have an MS Access 2000 query that I need to convert into a SQL Statment
for Access project and SQL Server backend.

One of the queries have an IIF(RecType="A",Name,COntactName). this is not
working how do I get this to work?

then how do I set the criteria to Forms!frmCust!txtCustID

Thanks
Dib

Reply to this Message

Kevin3NF - 28 Jun 2004 17:19 GMT

IIF statements need to be converted to SQL Server CASE logic, and to pass a
form value into your stored procedure, look at the Input Parameters property
in the data tab.

Something along the lines of:
@CustID = Forms!frmCust!txtCustID

HTH,

Signature

Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

> Hi,
> I have an MS Access 2000 query that I need to convert into a SQL Statment
[quoted text clipped - 7 lines]
> Thanks
> Dib

Reply to this Message

Dib - 28 Jun 2004 17:33 GMT

Thanks for the info

Dib

> IIF statements need to be converted to SQL Server CASE logic, and to pass a
> form value into your stored procedure, look at the Input Parameters property
[quoted text clipped - 16 lines]
> > Thanks
> > Dib

Reply to this Message