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

Nonexistant query being called during Union Query

P: 16
Access 2003 (2000 File Format)

I have a very complex string of queries (8 queries are ran when att empting to run the final Crosstab) and am receiving something odd on the 2nd to last one; a Union query. Whenever I run it an Enter Parameter Value window pops up which says 'Query1.EMPSOCIAL'. i went back to every query which this pulls from and they run correctly and thus have found no trace of 'Query1'. could this possibly be some glitch in Access with multiple queries being run consecutively?
Dec 7 '07 #1
Share this Question
Share on Google+
5 Replies


Rabbit
Expert Mod 10K+
P: 12,396
Access 2003 (2000 File Format)

I have a very complex string of queries (8 queries are ran when att empting to run the final Crosstab) and am receiving something odd on the 2nd to last one; a Union query. Whenever I run it an Enter Parameter Value window pops up which says 'Query1.EMPSOCIAL'. i went back to every query which this pulls from and they run correctly and thus have found no trace of 'Query1'. could this possibly be some glitch in Access with multiple queries being run consecutively?
Yes it is. I've run into this problem before. I've done some tests to see what causes this but for the life of me I can't recall the situation. However, when you're cascading queries, this can come up for some reason I can't remember.

If you could post the SQL for each of your queries perhaps it would jog my memory.
Dec 10 '07 #2

P: 16
This is the Union query, 2nd to last where the error occurs.

Expand|Select|Wrap|Line Numbers
  1. SELECT CBGCONTNUMBER, EMPSOCIAL, RELATION, LASTNAME, FIRSTNAME, MIDDLEINT, SUFFIX, ADDRESS, ADDRESS2, CITY, STATE, ZIPCODE, DEPARTMENT, HOMEPHONE, SEX, DOB, HIREDATE, MARITALSTATUS, ORIGINALEFFDATE, ACTION, EFFECTIVEDATE, CROSSTAB_VALUE, CROSSTAB_FIELD
  2. FROM qry_CBG_EE_MAX_c;
  3. UNION ALL SELECT CBGCONTNUMBER, EMPSOCIAL, RELATION, LASTNAME, FIRSTNAME, MIDDLEINT, SUFFIX, ADDRESS, ADDRESS2, CITY, STATE, ZIPCODE, DEPARTMENT, HOMEPHONE, SEX, DOB, HIREDATE, MARITALSTATUS, ORIGINALEFFDATE, ACTION, EFFECTIVEDATE, CROSSTAB_VALUE, CROSSTAB_FIELD
  4. FROM qry_CBG_EE_DEPS_a;
however, when i run the Crosstab query (the final) which follows the Union everything appears normal and there is no Paramter screen. i need to spot-ceck each record to be sure but is that normal??
Dec 13 '07 #3

Rabbit
Expert Mod 10K+
P: 12,396
Please use code tags. The problem isn't with the union per se. It's a combination of the queries you're using and the union. What is the SQL to the queries behind the union?
Dec 13 '07 #4

P: 16
i found it. Under the 'Properties' of that Union Query, it had an OrderBy Query1.EMPSOCIAL.
Dec 13 '07 #5

Rabbit
Expert Mod 10K+
P: 12,396
That'll do it, good job.
Dec 13 '07 #6

Post your reply

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