Hollis, Virginia
hollisvj at pgdp.usec.com
Fri Feb 2 09:03:02 CST 2007
Yes, it is for reports. This works, but same as Chesters - It shows the
COMMENTS in each field even if there aren't any comments. It doesn't do
that for the REMARKS or INV COMMENTS.
*******************
Aah you're using this in SQL aren't you, not code. Vbcrlf is VBA so
code-only. Ok, so going back to the chr(13) & chr(10) try:
("COMMENTS: "+[Comments]+(Chr(13) & Chr(10))) & ("REMARKS:
"+[Remarks]+(Chr(13) & Chr(10))) & ("INV COMMENTS: "+[InvComments])
--
Andy Lacey
http://www.minstersystems.co.uk