I'm looking for the maximum number of fields for a table and subsequent queries to fileter of that table...I can't find this in "Help"...is there an answer?

Hi,
how about this!
However, a word of caution...I hope you are familiar with normalization...just because the limit for table fields is kind of high it doesn't mean there should ever be that many in one table. A table having more then 20 fields might already indicate a wrong, denormalized structure.
HTH
Good luck

The max fields in a table is 255. But if you have this many, there's probably a normalization issue. After about 10 you should start looking at your structure. If you'd like, I can give you some links about normalization.

EDIT: Oli said the same thing but I thought I'd post this for emphasis.

I have a survey db. the main survey has 324 questions. Load the tables in unavoidable. I've already broken out the heading sections so they don't repeat. Response values will have to reside in a large table.

Wrong...I would strongly encourage you to read up on normalization...with this scenario you should have a seperate questions table which holds 324 records and is linked to your other records table. What happens if you need to add or delete a question...you wouldn't want to modify the table design, but rather just work with the records within the table.
Furthermore, search UA for many sample data models for survey questionnaires. They will help you set up your structure correctly.
HTH
Good luck

Here is an example of a properly normalized Survey DB.