Liz-
If they were ordinary Text fields, I would at least expect the constant literals
to show up. Trying to concatenate very large memo fields can be problematic.
I don't understand your comment that ProblemAndSuggestion is a memo field - it's
the name of your expression. What is in the Problem and Suggestion and WIPNotes
fields?
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Liz Ravenwood
Sent: Thursday, August 23, 2012 5:55 PM
To: 'MS_Access_Professionals@yahoogroups.com'
Subject: [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.
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar