However, except in very extremely exceptional database scenarios, you
should not need to consider this limit. 30 fields is a lot. I know you
didn't say so, but if you are looking at creating a table with a lot of
fields, you might consider asking some further advice first.
Open Help in Access and search for: Specifications
Here, you should see the following:
Number of fields in a table 255
That said, *most* tables do not exceed about 25~30 fields, if the database
is properly normalized. If the term normalization is unfamiliar to you, you
should read the first two database design papers, written by Michael
Hernandez, available here:
You should spend some time gaining an understanding of database design and
normalization before attempting to build something in Access (or any RDBMS
software for that matter). Don't underestimate the importance of gaining a
good understanding of database design. Brew a good pot of tea or coffee and
enjoy reading!
Then it should almost certainly NOT be done in a Table; in fact calculations
*cannot* be done in tables, though you can use table data *in* calculations.
Excel might be a better choice; you could write a VBA function to do the
calculations.
Perhaps we're not understanding what you mean here. Could you describe what
you are trying to accomplish (instead of how you want to accomplish it)?
Someone might have a simpler solution.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
