Incorrect Field Design

  • Thread starter Thread starter Big Tony
  • Start date Start date
B

Big Tony

I have designed some fields in my table in an incorrect
manner in two ways:

1. Used text fields where I really wanted numbers.

2. Made a 2 column field where I only really needed one.
furthermore, I have decided that it is not the bound
column that I want, but actually the other column.

Is there a way that I can remedy these problems with
simple queries, because I don't know how I would
repopulate the database if I had to delete a field and
start all over again.
 
You can add fields and then perform an update query to re-arrange your
values. I would question the reasons behind both of your changes.
 
Can I just delete the old field and rename the new field
with the same name once I am done and therefore retain
all references to this field in forms and reports?
 
Sure you can. I would recommend that you back up your mdb prior to making
any of these changes.
 
Back
Top