"Query Too Complex" ... but all data is needed

[Jennifer Cali]

I have a query that is too complex (i.e.: too many fields being calculated).
I have broken the data out to two separate queries and am able to run each
individually, but need to pull the resulting aggregate data onto a single
form. How can I do this? I can't just combine the two queries on the form b/c
there isn't a field that links them together so Access won't let me join
them.

 

[Calvin Luttrell]

Jen,

If you use a union statement to combine the results that should work.
However they have to bring back the smae exact scheme in order them to be
grouped together by the union. I beleive it works the same for access as sql
server. Have a look at this example.

http://www.blueclaw-db.com/accessquerysql/union_combo_box_all.htm


Calvin Luttrell

How e-commerce is done.

http://blog.projectthunder.com
http://www.projectthunder.com

 

[CurtainMary]

I have had error messages like that and eventually I discovered that they
were due to mixing left and right joins inappropriately. I suggest that you
have a real good look at the joins.
CurtainMary

 

[David Cox]

If the two sets of data are to go on the same form then I would assume that
there is some association between them. If you put a recipe and the name of
library books on the same bit of paper it might because you are planning a
trip to town. In that case you might create a field "triptotown" and
associate it with the recipe and the library books, and create a query to
join them. Now you have one query and one form and the world is a more
beautiful place.

Perhaps

 

[Ken Sheridan]

Jennifer:

Can you post the SQL of the original over-complex query, and of the two less
complex ones here. At present we don't have a lot of information to go on,
so are having to second guess what's required. I don't think a union is
likely to be the answer because, reading between the lines, it sounds like
you want to JOIN the result sets of the two less complex queries rather than
carry out a UNION operation.

Some explanation of what you are trying to achieve in terms of the data,
rather than how you are trying to do it would also help the dog to see the
rabbit.

Ken Sheridan
Stafford, England