Hollis, Virginia
hollisvj at pgdp.usec.com
Fri Feb 2 08:56:28 CST 2007
Ok, getting close. But now it shows the word COMMENTS: at the beginning
each field even if there isn't anything entered in the comments.
********************
That should be IIf not If. I forget switching back and forth between
Access and Excel.
Chester: This gives me an error: Undefinded Function If:
Desc: ("COMMENTS: "+If([Comments] Is Null,"",[Comments]) & (Chr(13) &
Chr(10) & "REMARKS:"+[Remarks]) & (Chr(13) & Chr(10) & "INV COMMENTS:
"+[InvComments]))