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?
5 1574
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.
This is the Union query, 2nd to last where the error occurs. - 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
-
FROM qry_CBG_EE_MAX_c;
-
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
-
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??
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?
i found it. Under the 'Properties' of that Union Query, it had an OrderBy Query1.EMPSOCIAL.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Bob |
last post by:
Hi there,
Need a little help with a certain query that's causing a lot of acid
in my stomach...
Have a table that stores sales measures for a given client. The sales
measures are stored per...
|
by: jimmyshaw83 |
last post by:
I am sorry if this topic is tired, but after all that I have read I am
still in the woods here. I have built a database to handle weekly and
monthly reports of what people are doing. They submit...
|
by: Lyn |
last post by:
Hi,
How do you bind the output columns from a UNION query when the fields from
the two tables have different names? Consider this query (WHERE clauses
omitted)...
SELECT SurnameBirth,...
|
by: sunilkeswani |
last post by:
Hi
I am still new to access. I want to know how i can build a query which
can display results from 4 different columns/fields
Like.
Field1 Field2 Field3 Field4
1 2 1 ...
|
by: BerkshireGuy |
last post by:
I have the following union query that works great, but I want to alter
the query to only return True (-1) for the TEST column.
Currently the test column DOES return 0 or -1. I just want the -1....
|
by: bgreenspan |
last post by:
Hi Everyone, I'm back for some more expert help. Here's what I am
doing and what I tried.
My database has entries with Contract Names and Expiry Dates, among
other fields. I have a form...
|
by: MLH |
last post by:
How can I turn the following into a make-table query?
SELECT & " " & AS Recipient FROM
tblVehicleJobs INNER JOIN tblAddnlOwnrs ON tblVehicleJobs.VehicleJobID
= tblAddnlOwnrs.VehicleJobID WHERE...
|
by: MLH |
last post by:
I have a saved UNION query named
qryAuthsOwnersAddnlOwnersLienholders4OneCar.
Here it is...
SELECT & " " & & " " &
& " " & & ", " & & "
" & & " " & "(" & & " county) " &...
|
by: OldBirdman |
last post by:
Assume 2 tables
tblP {Primary Table}
tblP.Key {AutoNumber and all that}
tblP.Name {Name of EE, Movie, Bird Species, or Whatever}
tblA {Alternate Table}
tblA.Key {AutoNumber and...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |