SQL Statment

  • Thread starter Thread starter Dib
  • Start date Start date
D

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
 
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.
 
Back
Top