SQL Statment

[Dib]

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

 

[Kevin3NF]

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,

--
Kevin Hill
President
3NF Consulting

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

 

[Dib]

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
in the data tab.

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

HTH,

--
Kevin Hill
President
3NF Consulting

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