M
Marco
Hi. How many fields can I create in each table?
Regards,
marco
Regards,
marco
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Steve Schapel
Marco,
255.
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.
255.
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.
T
Tom Wickerath
Hi Marco,
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:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html#DatabaseDesign101
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!
Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
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:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html#DatabaseDesign101
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!
Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
M
Marco
Hi. thanks bro's.
Yes I understand that I shouldn't have more than 30 fields.
This is a special case that I'm try to build a formula system calculation.
Regards,
Marco
Yes I understand that I shouldn't have more than 30 fields.
This is a special case that I'm try to build a formula system calculation.
Regards,
Marco
J
John W. Vinson
This is a special case that I'm try to build a formula system calculation.
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.
John W. Vinson [MVP]