Memo field in cross tab query

[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!

 

[KARL DEWEY]

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

 

[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.