Go Back   Access World Forums > Microsoft Access Discussion > Queries

Thread Tools Rate Thread Display Modes
Old 09-21-2019, 01:00 AM   #1
Newly Registered User
Join Date: Mar 2014
Posts: 5
Thanks: 4
Thanked 0 Times in 0 Posts
BoleMK is on a distinguished road
missing table in join query

Hi all,
I have join query of 3 tables. The third one is linked table from other location that is sometimes unavailable, so the linked table is missing from time to time. When this happens the query returns 'missing table' error.
Any idea how to avoid this, and get null result replacing the missing fields, so the other part of query returns data.

BoleMK is offline   Reply With Quote
Old 09-21-2019, 05:09 AM   #2
Pat Hartman
Super Moderator
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 28,163
Thanks: 15
Thanked 1,576 Times in 1,498 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Re: missing table in join query

Welcome aboard,

The structure of a query cannot be changed on the fly so the short answer is NO.

You could use VBA to determine the existence of the third table and run two different queries but whatever you are doing with the queries would also have to change since sometimes fields are present and sometimes they are not.

The real solution is to ensure that the table is always present. It may be empty as long as you are using left-joins but it MUST exist.
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
The Following User Says Thank You to Pat Hartman For This Useful Post:
BoleMK (09-22-2019)

missing table , querie fields

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
LEFT JOIN missing records nestoc Queries 3 05-06-2016 02:07 PM
Join Multiple Fields from One Table to the Same Table in a Query themurph2000 Queries 2 11-21-2014 12:56 PM
[SOLVED] Join Tables - Missing Data Adam McReynolds Queries 2 06-04-2014 03:54 PM
join 3 table query with dio.m Queries 7 06-16-2011 01:04 AM
1 inner join and 1 outer join and one table not joined in one query? ahvc Queries 2 05-13-2003 04:35 AM

All times are GMT -8. The time now is 04:25 AM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World