Start new row with an updatequery in a memo datafield

[johan]

Hello,

My question (problem):
I have a table with 4 datafields.
a = text, b = text, c = text, d = memo.

With an updatequery I want to registrate the data in field a, b en c
together in field d.
I know you can do did with a query with [a]&&[c] as updatecode in
datafield d.
What I want is to registrate them together, but after each datafield I
want an Enter which results in a new row within the memofield. So I
will get "a" then new row "b" then a new row "c".

Is there perhaps a code that I can use between [a] [c] that
automaticle result in a new row (just as you should use the enter
button when typing data in a memofield).

regards,
Johan

 

[Arvin Meyer [MVP]]

First, I'll tell you that it is a gross violation of database normalization
rules to put more than 1 value in a field. That said, here's how you do it:

Update MyTable Set [d] = [a] & Chr(13) & Chr(10) & & Chr(13) & Chr(10) &
[c] & Chr(13) & Chr(10) & [d]

 

[johan]

Arvin,
I'd registrate it in the SQL view and........
fantastic it works as needed.

Thanks.