Hello,



I have created a criteria form based on a query with 63 fields (which is

based on underlying table with same fields).  Each field is unique value

(aircraft licences).  My intention is to tick some boxes in the Criteria

Form, click a button, which will then (run the query) produce a list of

people with select set of licences.  I can put a link in every criteria

field in the query, but is there a limit of how many criteria fields can

access handle at any time ?



Thanks,



Vlad





Visit Qantas online at http://www.qantas.com.au



*******************Confidentiality and Privilege Notice*******************



This email is intended only to be read or used by the addressee. It is

confidential and may contain legally privileged information. If you are not

the addressee indicated in this message (or responsible for delivery of the

message to such person), you may not copy or deliver this message to

anyone, and you should destroy this message and kindly notify the sender by

reply email. Confidentiality and legal privilege are not waived or lost by

reason of mistaken delivery to you.



Qantas Airways Limited

ABN 16 009 661 901

Hi Vlad,

My personal philosophy is to give it a try and see what happens. It sounds 

like you'd only lose an hour if it doesn't work. If Access doesn't like 

your query, you could end up with the cryptic message: "Query too Complex".

THat tells you you're trying to do more than Access can handle.

... AL





> Hello,

> 

> I have created a criteria form based on a query with 63 fields (which is

> based on underlying table with same fields).  Each field is unique value

> (aircraft licences).  My intention is to tick some boxes in the Criteria

> Form, click a button, which will then (run the query) produce a list of

> people with select set of licences.  I can put a link in every criteria

> field in the query, but is there a limit of how many criteria fields can

> access handle at any time ?

> 

> Thanks,

> 

> Vlad

>