like in excel Transpose...

Question

I want a ATable that was transposed from BTable in Access..

i think it's possible  but I can't

 

Answer 1

In most situations, that wouldn't make sense in Access, but perhaps you can use a Crosstab query. See https://support.office.com/en-us/article/make-summary-data-easier-to-read-by-using-a-crosstab-query-8465b89c-2ff2-4cc8-ba60-2cd8484667e8

---

Regards, Hans Vogelaar (http://www.eileenslounge.com)