A
Abay
Hello,
I have a text field to which I would like to add the contents of another
field plus some more text. My update query is as follows:
Left([Desc],28) & [Pubdate] & "*BOOK" (Desc contains a book title)
I wish to add the contents of the field Pubdate starting at position 29 of
the Desc field, and append the *BOOK text after that.
The update works, however the Pubdate, and it's following text are added at
the end of the book title wherever that occurs, i.e. not at position 29,
unless the Title had 28 characters or more.
Any help with this would be most appreciated.
Abay
I have a text field to which I would like to add the contents of another
field plus some more text. My update query is as follows:
Left([Desc],28) & [Pubdate] & "*BOOK" (Desc contains a book title)
I wish to add the contents of the field Pubdate starting at position 29 of
the Desc field, and append the *BOOK text after that.
The update works, however the Pubdate, and it's following text are added at
the end of the book title wherever that occurs, i.e. not at position 29,
unless the Title had 28 characters or more.
Any help with this would be most appreciated.
Abay