Crosstab query with notes

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
 
E

Evi

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
 

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

Concatenate 4
concatenate from query 1
dcount in a crosstab query 3
dynamic crosstab query 2
Query a crosstab query 2
Make-table query with around 2 ml records taking too long 0
crosstab query 2
Crosstab query as data source for update query 7

Top