why will this not work? INSERT INTO #TEMP SELECT * FROM a WHERE b IS NOT NULL
R RobFMS May 20, 2004 #2 Are you writing a query for a SQL Server db or for an Access db? -- Rob FMS Professional Solutions Group http://www.fmsinc.com/consulting Software Tools for .NET, SQL Server, Visual Basic & Access http://www.fmsinc.com -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Are you writing a query for a SQL Server db or for an Access db? -- Rob FMS Professional Solutions Group http://www.fmsinc.com/consulting Software Tools for .NET, SQL Server, Visual Basic & Access http://www.fmsinc.com -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
