Incorrect Field Design

[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.

 

[Duane Hookom]

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.

 

[Big Tony]

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?

 

[Duane Hookom]

Sure you can. I would recommend that you back up your mdb prior to making
any of these changes.