Help

[amfroehlich]

I am getting an error saying "Query is too complex". What does this mean? Is their a maximum number of items that can be on a query?

 

[Norie]

an error saying "Query is too complex

Generally it means that Access hasn't been able to 'resolve' some function or other in the query.

Can you post the SQL? Or give some details of the query?

 

[amfroehlich]

SELECT NumbersofBids.*, NumbersofExpediting.*, NumbersofMSDS.*, NumbersofNewProduct.*
FROM NumbersofBids, NumbersofExpediting, NumbersofMSDS, NumbersofNewProduct;

 

[Norie]

NumbersofBids, NumbersofExpediting, NumbersofMSDS, NumbersofNewProduct

Are these queries or tables?

Are they linked at all?

 

[amfroehlich]

these are all queries and no they are not linked.

 

[Norie]

no they are not linked.

So why have you got them in a query together?

If you don't link tables Access will return for each record in each query return all the records in the other queries.

A small example

Table1

x	y
a	b
c	d


Table2

v	w
e	f
g	h

Query 

SELECT Table1.*, Table2.*
FROM Table1, Table2;

returns

x	y	v	w
a	b	e	f
c	d	e	f
a	b	g	h
c	d	g	h

So records in Table1 = 2, records in Table2 = 2 , records returned 2*2.

Adding another table would mutiply the no of records returned again.

This could be causing the error as

No of records returned = No of records in NumbersofBids*No of records in NumbersofExpediting*No of records in NumbersofMSDS*No of records in NumbersofNewProduct

EDIT

Just carried out a 'small' test 5 tables, each table 2 fields and 16 records each:

QUERY

SELECT Table1.*, Table2.*, Table3.*, Table4.*, Table5.*
FROM Table1, Table2, Table3, Table4, Table5;

returns 1,048,576 records.