Memo field in cross tab query

A

Anne721

Am using Access 2007. I'm linking to a "View" in SQL Server 2005. I want to
create a crosstab query based on that view, however some of the fields in the
view table are Memo and will not show up as options in the cross tab query
wizard.

Is there a work around for this?

Thanks! Your help is very much appreciated!
 
K

KARL DEWEY

You could use a select query that has calculated field to pull the left 255
character of the memo field.
 
P

Pat Hartman

I am assuming that you are not trying to use the memo for anything other
than a Row Heading. That being the case, do the crosstab without the memo
field and then join the crosstab query back to the table to pick up the memo
field.
 

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

How to display zero value in blank fields of Cross Tab query 0
Cross Tab Report Vs Dynamic coulmns 0
Basing a report on an updated cross-tab query 2
Ordering of Cross Tab Query 7
Cross Tab Query Data Entry 5
Memo Field - Won't allow type 4
Problem With Parameters in Cross Tab Query 0
Query in vb.net not returning all characters in access memo field 1

Top