If you have "too many fields", try splitting your table in
two, use (or create) a common/key field and run queries
joined on the common/key field. Even 200 fields is
usually too many to manipulate.
If you have "too many fields", try splitting your table in
two, use (or create) a common/key field and run queries
joined on the common/key field. Even 200 fields is
usually too many to manipulate.
Well, kind of; but the point is not to chop this spreadsheet in two, but to
remove all the repeated and dependent fields into their own multiple
tables. This is the process known as normalisation, and usually results in
tables with fewer than twenty fields -- it's extremely rare to go over
thirty.
B wishes
Tim F
Ask a Question
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.