Update Table Record with Memo Field

[perrymans]

I am trying to do an Append with multiple Memo fields and it does not work (clips the data, it is a long story with many blanks and grouping).

So I thought I would do an Update query for each field, but I can't seem to get it to work.

What is the proper way to Update when the value I want is not null and the two key fields are equal using an update query?

Or is there a better way?

When I try and do an Update, it wants to do 3332 records instead of the 23 that are actually there.

Thanks. Sean.

 

[PHV]

Why not use a bound form ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[perrymans]

The back story is:

I am importing a text file into a datbaase via Excel. The data is semi-structured but I have to sequence through it and prep it in Excel, then do a transferspreadsheet into access. Once in, one record may have 20 records because the data is spread out over several columns like:

Input     F1      F2      F3
Blah1, b  Blah1
lah2, bl          blah2
ah3                       blah3

So in this case, you see there are three records in three different columns, and I need to append it to be like:

F1      F2      F3
Blah1   blah2   blah3

I can't do it in one query because Memo fields won't work with Group By. So I did separate select queries first that fed one append, but now the Append is clipping the field length.

So there is not form, just Excel to table to another table.

Thanks. Sean.

 

[perrymans]

I just found a previous thread of mine (thread702-1468969) which had a solution (the SQL), but it does not work with Memo fields.

Thanks. Sean.