Results 1 to 2 of 2

Thread: Problem Executing Unions

  1. Apr 26th, 2000, 09:21 AM #1
    Guest

    Cool

    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.
    Reply With Quote Reply With Quote
  2. Apr 26th, 2000, 10:02 AM #2
    Mongo
    Mongo is offline
    Hyperactive Member
    Join Date
    Nov 1999
    Location
    Leavenworth KS USA
    Posts
    482
    Set SearchRec = AutoSalonDb.OpenRecordset(SQLStri [missing an "n" here?] g, dbOpenSnapshot)

    [Edited by Mongo on 04-26-2000 at 11:13 PM]
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width