Using a query to make a table and losing data

[Guest]

Hello all,

To remove some redundancy between different but similar tables I have a
query which a field I defined that uses the Iif statement to compare memo
field A and memo field B in a database and choose A if it is <> "" and B
otherwise. i.e.

Iif(MemoFieldA <>"", MemoFieldA, MemoFieldB)

But when I use this to create a table the resulting field is a Text field
and of course loses any information beyond 255 characters. I can't see how to
specificy the field type in the query. Help!

Thanks for any help.

Cheers,

Alasdair

 

[[MVP] S.Clark]

You could create the query ahead of time, then append the new data to the
existing structure. This will allow you to write to a Memo field.

 

[Guest]

Steve,

Thanks, that is a practical solution.

Do you know why this conversion error is happening? I have other fields I am
using Iif to select between two values and I haven't seen any other
conversion errors but should I go through them 1-by-1 and check closely? The
majority of other fields I am creating are text with some date types as well.

Cheers,

Alasdair