Croostab Query with memo fields...

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

Guest

Hi,

In Access it is not possible to use fields of type memo in a crosstab.
Does anyone knows how to solve this another way?

Please let me know...

Kind regards,
Jan
 
Hi,




Assuming each memo is different, and assuming you use primary key, I would
use the primary key, rather than the memo, and NEXT, use another query that
will join through the primary key to "SELECT" the memo (in that outer most
query, using the initial table AND the crosstab_with_pk_rather_than_memo).




Hoping it may help,
Vanderghast, Access MVP
 

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

disctinct query memo field 3
Make Table Query Truncating Memo Field at 255 Characters 2
Memo fields not displaying in query 4
memo field in the select query 2
Dates in a memo field 3
Memo fields in a query 4
Selecting Distinct Memo Fields 1
Crosstab query with notes 1

Back
Top