Member_2_7966563
asked on
Could someone write me an SQL query for MS Access?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect solution, worked out of the box!!
ASKER
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?
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?
see
Make summary data easier to read by using a crosstab query
Also try this:
https://www.youtube.com/watch?v=0v-ILGUtGFo