move fileds in a table

[Guest]

I have created a table with a large number of fields. Now I want to move some
of these fields within the table. Can it be done? In addition, I also have
created a form from this table, if I move the fields in the table, will it
have some effect on the form?
Miguel

 

[Guest]

hi,
what do you mean with move fields?
Furthermore I'm suspecting that you did not normalize your data correctly or
do not understand normalization.
Access does not work like flatdata files (excel). It is a relational
database environment. Having a really large table with many fields most of
the time means that you did not set up a correct data model. This is vital in
database development as everything is based on that, so make sure that you
understand this.
HTH
Good luck

 

[Douglas J Steele]

What do you mean by moving fields? Changing the order in which they appear?
There's no reason to care about the order of the fields in the table: create
a query that has the fields in whatever order you want (not that it should
matter...), and use the query wherever you would otherwise have used the
table.