[MS_AccessPros] concatenation of nz expressions

 

Pros, I'm wondering why this expression is showing blank:

ProblemAndSuggestion: "Problem: " & nz([Problem],"") & " Suggestions: " & nz([Suggestions],"") & " WIP: " & nz([WIPNotes],"")

(part of a query)

ProblemAndSuggestion is a memo, and the other fields are also memo fields-- I believe.

Liz Ravenwood
Programmer/Analyst
Super First Class Products
B/E Aerospace
O: 1.520.239.4808
www.beaerospace.com
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (7)

Recent Activity:

• New Members 4
• New Files 1

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___