Thanks for the suggestion - works great in the query but when I use the
query
in a report the following error messsage is received
Reserved error (-1038): there is no message for this error.
HELP
--
Access Novice
:
Try change the memo field row heading from Group By to First.
--
Duane Hookom
MS Access MVP
Please see below - thanks (memo field is being used as row heading)
TRANSFORM Count([tblMaster RESPONSE Y/N].TOTAL) AS CountOfTOTAL
SELECT [tblMaster RESPONSE Y/N].[SUB-BUSINESS], [tblMaster RESPONSE
Y/N].FUNCTION, [tblMaster RESPONSE Y/N].[QUESTION #],
tblQUESTIONS.Description, Count([tblMaster RESPONSE Y/N].TOTAL) AS
[Total
Of
TOTAL]
FROM tblQUESTIONS INNER JOIN [tblMaster RESPONSE Y/N] ON
tblQUESTIONS.[QUESTIONS #] = [tblMaster RESPONSE Y/N].[QUESTION #]
GROUP BY [tblMaster RESPONSE Y/N].[SUB-BUSINESS], [tblMaster
RESPONSE
Y/N].FUNCTION, [tblMaster RESPONSE Y/N].[QUESTION #],
tblQUESTIONS.Description
PIVOT [tblMaster RESPONSE Y/N].RESPONSE In ("YES","NO");
--
Access Novice
:
Where are you using the memo field (row heading, column heading
[shudder],
value)?
Can you share your SQL view and tell us which field is the memo?
--
Duane Hookom
MS Access MVP
I have created a crosstab with a field that is identified as a
Memo
in
the
table, but once I create the crosstab - the text in the field is
not
complete
- it ends after so many characters. Can someone point me in the
right
direction - ex:" The information in this field is not containing
all
the
information that is contained in the field in the table. This
prob