error in Access
Hello Everyone,
If I run the following query in MySQL Control Center or MySQL-Front it works
correctly,
SELECT -1 AS ProductID, Add New Part AS PartNumber, AS VendorPartNo,
AS Description, AS VendorStatus FROM Products UNION SELECT ProductID,
PartNumber, If(SubNo=1135
The MS Access SQL syntax for if() is iif(condition, then stuff, else
stuff)
Maybe that's the problem, I am not sure - try it
Freddie
-Ursprüngliche Nachricht-
Von: Ed Reed [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 26. Februar 2004 02:09
An: [EMAIL PROTECTED]
Betreff: Query error
Hello Everyone,
If I run the following query in MySQL Control Center or MySQL-Front it
works correctly,
SELECT -1 AS ProductID, Add New Part AS PartNumber, AS
VendorPartNo, AS Description, AS VendorStatus
FROM Products
UNION SELECT ProductID, PartNumber, If(SubNo=1135,