By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,466 Members | 2,171 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,466 IT Pros & Developers. It's quick & easy.

Union Query problem

daniel aristidou
100+
P: 491
hi i made a union query to join about 9 tables together. however when i press run an error message apears saying that it could not find object: ".
Any way so i started again and ran it after every new table joined. and the error only occurs after the 3rd table entry. but after the third table entry is removed the error message remains and it will not run.
Does any body know why this happens. I have not even typed in any ".
Also can anyone answer where to put a where that stands for the whole query
where [date finished] is null

Thanks in advance for any help.....
I use access 07
Sep 16 '07 #1
Share this Question
Share on Google+
3 Replies


puppydogbuddy
Expert 100+
P: 1,923
hi i made a union query to join about 9 tables together. however when i press run an error message apears saying that it could not find object: ".
Any way so i started again and ran it after every new table joined. and the error only occurs after the 3rd table entry. but after the third table entry is removed the error message remains and it will not run.
Does any body know why this happens. I have not even typed in any ".
Also can anyone answer where to put a where that stands for the whole query
where [date finished] is null

Thanks in advance for any help.....
I use access 07
Daniel,

It would be more helpful if you posted your query so we do not have to guess at what the problem is. Usually, I have seen the "could not find object" message occurring when the object referred to (i.e. a field or table) has spaces in the name, and the name is not enclosed by brackets as required....or the name is misspelled. The where clause usually goes in the first select statement if it is applicable to the whole query.
Sep 16 '07 #2

daniel aristidou
100+
P: 491
Daniel,

It would be more helpful if you posted your query so we do not have to guess at what the problem is. Usually, I have seen the "could not find object" message occurring when the object referred to (i.e. a field or table) has spaces in the name, and the name is not enclosed by brackets as required....or the name is misspelled. The where clause usually goes in the first select statement if it is applicable to the whole query.
So if the form name has a space(which they all do) this could result in the problem?
This still does not explain the why it only happens after the 3rd table is entered.
Since all of the forms areexactly the same just with diif names
Sep 16 '07 #3

puppydogbuddy
Expert 100+
P: 1,923
So if the form name has a space(which they all do) this could result in the problem?
This still does not explain the why it only happens after the 3rd table is entered.
Since all of the forms areexactly the same just with diif names
Sometimes the compiler is "forgiving" and will encapsulate the name for you....generally, it won't. Did enclosing all the form names in brackets solve your problem?
Sep 16 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.