-
I get an error when I try to execute the following SQL statement. If I execute each select statement by it's self, it runs fine. When I put them together with a union I get an error. The tables exist and the names are spelled correctly. Any insight is appreciated.
SQLString = "SELECT SALEID FROM PRESALES UNION ALL SELECT SALEID FROM SALES"
Set SearchRec = AutoSalonDb.OpenRecordset(SQLStrig, dbOpenSnapshot)
Error
Run-time error '3078'
The microsoft jet database engine can not find the input table or query. Make sure it exists and that its name is spelled correctly.
-
Set SearchRec = AutoSalonDb.OpenRecordset(SQLStri [missing an "n" here?] g, dbOpenSnapshot)
[Edited by Mongo on 04-26-2000 at 11:13 PM]
