How to Convert a Normal Query to a Crosstab Query in Access

in #access20166 years ago (edited)

https://www.microsoft.com/en-us/videoplayer/embed/RWejjl?pid=ocpVideo0-innerdiv-oneplayer&postJsllMsg=true&maskLevel=20&market=en-us

https://www.quackit.com/microsoft_access/microsoft_access_2016/howto/how_to_convert_a_normal_query_to_a_crosstab_query_in_access_2016.cfm

"Turn a select query into a crosstab query for a more readable set of results.

Sometimes a normal (select) query will return results, where, some fields need to be duplicated in order to show all the data.

A crosstab query allows you to group the query results in a way that removes the duplicate values, and presents the results in a way that makes them easier to read and decipher."

Sort:  

Congratulations @crypto-burrito! You received a personal award!

Happy Birthday! - You are on the Steem blockchain for 1 year!

You can view your badges on your Steem Board and compare to others on the Steem Ranking

Do not miss the last post from @steemitboard:

SteemitBoard - Witness Update
Vote for @Steemitboard as a witness to get one more award and increased upvotes!