What is the maximum number of fields you should have in a table?

While Access limits the number of fields in a table to 255, it is very rare to need this many columns in a properly normalized database. There is no set number that you "should" have in a table - that number is dictated by the data you will be storing and how the different bits of data relate to each other.
Here are a few great links on normalization, which is the process of splitting up your data and defining what tables you will need in a relational database. I strongly suggest you become familiar with the concept,

HTH
Matt

• Database planning tutorial Part I
• Database planning tutorial Part II
• argeedblu's FAQ on Design Strategies
• Noah's FAQ on Normalization
• Jerry's FAQ on Normalization
• GroverParkGeorge's PDF on Normalization
• Jerry’s FAQ on Fully Qualified Naming
• Jerry's FAQ on Glossary
• Danny's FAQ on Reserved Words
• Autonumbers - What They Are / Are Not
• Primary Keys - Natural vs Surrogate
• Naming Conventions - Hungarian Notation
• Crystal's ACCESS Basics for Programming
• Database Answers (free models)
• MSKB 283878: Description of the database normalization basics

I'll check those out. Thanks for the information.

np!
Good luck with your db..