Search results

  1. C

    Help Creating Query To Ignore Statement If File Doesn't Exist

    That seems to work great. Still running a few different scenarios but it seems to be doing the job. Thank you.
  2. C

    Help Creating Query To Ignore Statement If File Doesn't Exist

    So you're suggesting completely eliminating the UNION query and creating separate APPEND queries for each of these tables, right? I didn't consider that. I'll give that a shot, thank you.
  3. C

    Help Creating Query To Ignore Statement If File Doesn't Exist

    I guess over the grand scale of my project it doesn't. Thank you for the new idea.
  4. C

    Help Creating Query To Ignore Statement If File Doesn't Exist

    For as much as I would like to, I'm trying to make this database as automatic as possible so all someone has to do is open the file and see the info they want.
  5. C

    Help Creating Query To Ignore Statement If File Doesn't Exist

    Hello all, I am working with a rather large database that references 10 other Access files. These files are referenced through linked tables in my database, and I am trying to create a union query with SQL that will select certain columns from all of the linked tables. I have the following code...
Back
Top Bottom