Update querry to memo field - How do I add a carriage return?

[FatMan]

Hi all:

I have an update query where I am updating a “memo†field. What I would
like to do is add the update to the memo field in front of the existing data.
My query all ready does this but I would like to add a carriage return
between the update and the existing date.

What I have in my query so far is:
[f15] & " - " & [f13] & ", " & [ctCustNotes]

Where [F15] and [F13] is the update and [ctCustNotes] is the memo field
containing the existing data and the field to be updated. What I need to
know is how do I replace the ‘& ", " &’ with a carriage return/hard return.

Any help would be greatly appreciated.

Thanks,
FatMan

 

[Duane Hookom]

[f15] & " - " & [f13] & Chr(13) & Chr(10) & [ctCustNotes]

 

[fredg]

Hi all:

I have an update query where I am updating a ¡§memo¡¨ field. What I would
like to do is add the update to the memo field in front of the existing data.
My query all ready does this but I would like to add a carriage return
between the update and the existing date.

What I have in my query so far is:
[f15] & " - " & [f13] & ", " & [ctCustNotes]

Where [F15] and [F13] is the update and [ctCustNotes] is the memo field
containing the existing data and the field to be updated. What I need to
know is how do I replace the ¡¥& ", " &¡¦ with a carriage return/hard return.

Any help would be greatly appreciated.

Thanks,
FatMan

[f15] & " - " & [f13] & chr(13) & chr(10) & [ctCustNotes]

Note: the chr(13) & chr(10) must be in that order.

 

[FatMan]

Duane:
Thanks!
FatMan

[f15] & " - " & [f13] & Chr(13) & Chr(10) & [ctCustNotes]

--
Duane Hookom
MS Access MVP

Hi all:

I have an update query where I am updating a "memo" field. What I would
like to do is add the update to the memo field in front of the existing
data.
My query all ready does this but I would like to add a carriage return
between the update and the existing date.

What I have in my query so far is:
[f15] & " - " & [f13] & ", " & [ctCustNotes]

Where [F15] and [F13] is the update and [ctCustNotes] is the memo field
containing the existing data and the field to be updated. What I need to
know is how do I replace the '& ", " &' with a carriage return/hard
return.

Any help would be greatly appreciated.

Thanks,
FatMan

 

[FatMan]

Thanks!
FatMan

Hi all:

I have an update query where I am updating a “memo†field. What I would
like to do is add the update to the memo field in front of the existing data.
My query all ready does this but I would like to add a carriage return
between the update and the existing date.

What I have in my query so far is:
[f15] & " - " & [f13] & ", " & [ctCustNotes]

Where [F15] and [F13] is the update and [ctCustNotes] is the memo field
containing the existing data and the field to be updated. What I need to
know is how do I replace the ‘& ", " &’ with a carriage return/hard return.

Any help would be greatly appreciated.

Thanks,
FatMan

[f15] & " - " & [f13] & chr(13) & chr(10) & [ctCustNotes]

Note: the chr(13) & chr(10) must be in that order.