Sometimes we just need to pivot our data in a way that makes sense for reporting purposes, and the crosstab query in Microsoft Access gives us that capability as we prepare data for reporting, statistics, or data science usage. Crosstabs are a very handy way to accomplish some otherwise difficult data transformation, and knowing how to use them is important for your data toolkit! Related Videos: How to Use Union Queries in MS Access https://www.youtube.com/watch?v=LHWYq5NgxgI How to Split One Column Into Two in Access Using the Split Function https://www.youtube.com/watch?v=vQX0taPQLB0 How to Query the Last Row in a Series in Microsoft Access https://www.youtube.com/watch?v=5cnwHyn4dnI How to Format Dates in MS Access Queries, Forms, and VBA Code https://www.youtube.com/watch?v=TaohJxP0-MI How to Use Nz in Microsoft Access to Handle Null and Empty Values https://www.youtube.com/watch?v=CR3FmVoRFys How to Use Crosstab Queries in MS Access You are watching this video now! How to Use Functions in MS Access Queries https://www.youtube.com/watch?v=i9W1Abkg5cs Want to get access to premium content made just for you and have a chat with me? Find me on Patreon : https://www.patreon.com/mackenziedataengineering Demo of my BZ RDP Cloaker: https://www.patreon.com/posts/how-to-block-rdp-98471703?utm_medium=clipboard_copy&utm_source=copyLink&utm_campaign=postshare_creator&utm_content=join_link Want to work with me 1:1? Contact me today and book your free 20 min consultation! Contact form you can find at http://www.mackenziemackenzie.com/ Follow me on social media: https://www.facebook.com/mackenziedataanalytics https://twitter.com/seamacke https://www.instagram.com/seamacke/ https://www.reddit.com/user/seamacke https://www.linkedin.com/in/psmackenzie/ Get Microsoft Office including Access: https://click.linksynergy.com/fs-bin/click?id=BdGJecFFM8A&offerid=1160033.10004289&type=3&subid=0 Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try: https://www.tubebuddy.com/seanmackenziedataengineering #CrosstabQuery #MSaccess https://www.youtube.com/watch?v=XRLS-XJ79ns