Crosstab query with notes

  • Thread starter Thread starter David Marks
  • Start date Start date
D

David Marks

I have a table with 3 fields to be used in a crosstab query:
PersonID
GroupID
ConCat

RowHeader: Person ID
ColumnHeader: GroupID
Value: ConCat

The problem is that ConCat is a MEMO field because it has more than 255
characters. Is there a way to get this long information into a crosstab query?

Thanks
David
 
The wizard won't let you do this, but it you create a query, go to the query
type button and turn it into a crosstab, choose GroupBy (in the Totals row)
and RowHeader (in the Crosstab row) for PersonID, GroupBy and ColumnHeader
GroupID with First and Value for ConCat.

Evi
 
Back
Top