How to write following part of SELECT query in SQL Server:
IIf(tblOrders!OrderTypeID=2 Or tblOrders!OrderTypeID=3,[DateCompleted],[DateOut]) AS ProgramDate,
Int(Nz([Lectures],1)) AS Programs, Int(Nz([Contacts],0)) AS TotalContacts
Novice
Windows 7 64bit 
Access 2007
How to write following part of SELECT query in SQL Server:
IIf(tblOrders!OrderTypeID=2 Or tblOrders!OrderTypeID=3,[DateCompleted],[DateOut]) AS ProgramDate,
Int(Nz([Lectures],1)) AS Programs, Int(Nz([Contacts],0)) AS TotalContacts
Novice
Windows 7 64bit Access 2007
Anybody??Access + sql experts??
Rewriting SQL Server Query to Access query not without problems
Posting Permissions
Reply With Quote