fields in a table

[Guest]

How many fields can you create in a single table? Does access have a limit?
The fields would be 10 characters each.

Thanks.

 

[Rick B]

Did you look at the help fields for your answer before posting? Please use
available resources before posting to a newsgroup.

In answer to your question, you can have 255 fields, but you should not have
more than 20 or 30 fields in a properly normalized database.

Access is not a spreadsheet. Data should be properly broken into smaller
"related" tables of data (thus the term "relational database").

If you need help normalizing your design, then you would need to tell us
what data will be stored and give us some examples.

 

[Rick B]

Please note, in my second paragraph I did not mean 20 or 30 fields in a
properly normalized *database*. I meant to say *table*.

Each table should have a relatively small number of fields.

 

[Joseph Meehan]

How many fields can you create in a single table? Does access have a
limit? The fields would be 10 characters each.

Thanks.

254 as I recall. However I have never seen a properly designed
database that had a table with anything close to that many fields. Usually
I only see that many fields from a spreadsheet user who does not understand
how to normalize data for a database.