My query is too complex

[Guest_imported]

I have run a query from writing SQL in VBA code on my form. I have over a hundred fields that I search but when I run the query it says that it is too complex. I have taken a few fields out and it works so I presume that it has something to do with a limitation with access 2000, can anyone suggest a way around this.

Thanks

Jonathan

 

[chrisgreen]

Have you tried setting up several queries to do the job.

 

[Guest_imported]

I have thought about that but how do I recombine them at the end to show one table of result instead of two tables.