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
 
Back
Top