Hi,
I am looking for a solution where the values in the memo field is truncated to 455 characters. I update the record with the following query.
ex:
"UPDATE HIST_IM INNER JOIN INGRAM ON [HIST_IM].[INGRAM_PAR]=[INGRAM].[INGRAM_PAR] SET HIST_IM.DEALER_PRI = [INGRAM].[DEALER_PRI] & ':' & '" & strDate & "' & ';' & [HIST_IM].[DEALER_PRI]
WHERE ([INGRAM].[INGRAM_PAR]=[HIST_IM].[INGRAM_PAR]) "

The 'DEALER_PRI' is a memo filed and 'INGRAM_PAR' is a primary key.
In this case i want to store the previous date and current date with the price.
Can someone out there please help me? I am using MS ACCESS 2007.

Thanks in advance

I think you can find a solution here: http://allenbrowne.com/ser-63.html

JR

Thanks a lot for the quick reply.

I will just mention that doing appending to memo fields for tracking is not a good idea. You should use RECORDS in another table to append a new record for each time you need something instead of appending to the memo field. Not only would that eliminate your issue but it would also let you gather that information back with no problem. The current method is not much good for anything.