Max no. of Criteria in a Query

[creed]

Hello

I using Access 2003 and am pretty new to it. I have a table with 150 different fields (checkboxes, Yes/No, Text, Date) which are populated by a user filling out a form.

There are 21 fields in particular I wish to find out if they have been left blank or if the user has selected "no data" for certain fields.

In design view you can only enter upto 9 different criteria for a query. So at the moment I have to create 3 separate queries, then play around in excel to match up the different ID's.

Is there a better way of doing this that will return the result of these 3 queries into 1 table? Or can I use 1 query

Any help is most appreciated!

Nik

 

[Scooterbug]

having 150 fields in one table screams of a design flaw. Read up on Normalization.

 

[creed]

I know. Ive inherited this monster and 2500 records have already been entered into it. Unfortunately, I dont have the time to redesign the database, but need to use it to find out all the missing info, etc

 

[Scooterbug]

Without knowing the table structure, I dont think I can be much help. The only suggestion is that if the design grid doesn't have enough lines, you are going to have to manually write the Sql.

Personally, as much as may be a pain, I would redesign it. I dont know what time contstraints you are under, or if you have pressure from a boss/superior but I would tell them that the database is flawed and you need to redesign it. I would start by quickly mapping out the tables, and use append queries to sort out the data.

Good luck