Merge tables

[Dan @BCBS]

I need to merge data from two tables into one, but some of the fields that
need to be merged are of different formats - Table #1 has numerical and Table
#2 has Text.

 

[Rick B]

Well change one. There are functions out there to get the numerical value
of a text field, or you can change the numercail field into text for the
merge. Or make them into two fields in the new table.

 

[Dan @BCBS]

I've been trying to.
I cannot just change the datatype to match the other table because I loose
files.

If I use an Update Query, this does not merge, I still have two variables,
which I'm trying to merge into one.

I'd like to change a text field to numerical at the Table level, then I can
just cut and paste the files.

 

[Rick B]

You will most likely lose data. You can't change a text field to a
numerical without losing the alpha characters.

 

[Dan @BCBS]

I changed the format on the FORM to text, which changed all the Y to 1 and
the N to 0. Now, how can I do that to the table, it still reads Y and N,
even though the cell on the form is now formated to TEXT???
Are you telling me the only way is to lose the data??

 

[Rick B]

I thought we covered this yesterday.

Do some update queries to change all the values to match, then change the
type.

Make all the Y's into -1 and all the Ns into 0s. Then change that field to
yes/no (boolean) in table design.

Rick B

 

[Dan @BCBS]

In an Update Query, changing all Y's to N's or an arithimatic is not a
problem, but can you give me an example of something that will look at the
fields value and change it. Example: IF (Field) = Y then -1, Else (Field)
= 0.

 

[John Vinson]

In an Update Query, changing all Y's to N's or an arithimatic is not a
problem, but can you give me an example of something that will look at the
fields value and change it. Example: IF (Field) = Y then -1, Else (Field)
= 0.

Run an Update Query updating the field to:

IIF([Field] = "Y", -1, 0)


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps