Crosstab - field limits

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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?
 
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


Duane Hookom said:
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

Melissa said:
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
Click to expand...
Click to expand...
 
Try change the memo field row heading from Group By to First.
--
Duane Hookom
MS Access MVP

Melissa said:
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


Duane Hookom said:
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

Melissa said:
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
Click to expand...
Click to expand...
Click to expand...
 
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


Duane Hookom said:
Try change the memo field row heading from Group By to First.
--
Duane Hookom
MS Access MVP

Melissa said:
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


Duane Hookom said:
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
Click to expand...
Click to expand...
Click to expand...
 
Changing from Group By to First will change the name of the column in the
crosstab. Did you update your report or your SQL?

--
Duane Hookom
MS Access MVP

Melissa said:
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


Duane Hookom said:
Try change the memo field row heading from Group By to First.
--
Duane Hookom
MS Access MVP

Melissa said:
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
Click to expand...
Click to expand...
Click to expand...
 
I did update the report to include the new field name....any other
suggestions? Thanks for all your assistance
--
Access Novice


Duane Hookom said:
Changing from Group By to First will change the name of the column in the
crosstab. Did you update your report or your SQL?

--
Duane Hookom
MS Access MVP

Melissa said:
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


Duane Hookom said:
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
Click to expand...
Click to expand...
Click to expand...
 
I'm at a loss. Are you attempting to sort or group by the field?

--
Duane Hookom
MS Access MVP

Melissa said:
I did update the report to include the new field name....any other
suggestions? Thanks for all your assistance
--
Access Novice


Duane Hookom said:
Changing from Group By to First will change the name of the column in the
crosstab. Did you update your report or your SQL?

--
Duane Hookom
MS Access MVP

Melissa said:
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
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Crosstab query with notes 1
update query 2
Make-table query with around 2 ml records taking too long 0
Crosstab 3
Query a crosstab query 2
Crosstab not showing null values/fields 5
crosstab query 1
Crosstab query and Lookup field problem 3

Back
Top