Link to home
Start Free TrialLog in
Avatar of Member_2_7966563
Member_2_7966563

asked on

Could someone write me an SQL query for MS Access?

The job of the query would be to take a table, like the one on the left, and convert it into a table like the one on the right:

User generated image
Avatar of PortletPaul
PortletPaul
Flag of Australia image

Access provides a "crosstab" to do this,  It is an option in the Create > Query Wizard > "Crosstab"

see
Make summary data easier to read by using a crosstab query

Also try this:
https://www.youtube.com/watch?v=0v-ILGUtGFo
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Member_2_7966563
Member_2_7966563

ASKER

Perfect solution, worked out of the box!!
Hi, Thanks a lot for the solution! It worked out of the box without me having to do anything. Could you also help me with one more?

In tblAnimals, if there was another column "How it Does it", and we need further columns in the output table named How1, How2, How3, etc, what would be the new query?