Crosstab Queries in Microsoft Access - Similar to Pivot Tables in Excel

[@krzysztofzborowski1975]

It’s been 10 years and it’s still the best tutorial I’ve found. Thank you, Rick! My journey with access started from your videos, and I love it! Can’t wait to see upcoming videos. Cheers!

[@vladisan1]

Very good explanation. I was struggling to create it by just writing the SQL but had issues. This makes it a lot easier!

[@599CD]

My pleasure.

[@kimmoore3994]

You are a very good teacher!

[@599CD]

Thanks

[@Roger-mg8zh]

Thanks ! exactly what I need for my dashboard from access basic data base with a further link to Excel later for charts from cross tab data.

[@599CD]

Glad it was helpful!

[@rajendraparakhi550]

Very nicely explained Sir , Thank you

[@599CD]

You are welcome

[@howtomakeanovallampshadeha7794]

Great introduction

[@599CD]

Thank you kindly

[@onyokvillaganes47]

This Help me a lot to my work.....

[@kensimba7868]

Well explained piece. Thanks sir

[@599CD]

Welcome

[@abdusaziz1266]

Excellent tution

[@599CD]

Many thanks!

[@raghadcode]

Thank you! saved my grades

[@599CD]

You're welcome.

[@johndavy3820]

As useual, you did an excellent job

[@599CD]

Thanks

[@AbhaGupta]

Good explanation!!

[@599CD]

Thanks!

[@mrbohra]

You r true master

[@arpitpatel14591]

Really Helpful..Thanks alot

[@599CD]

Welcome

[@f5zn57]

As Usual handy tips. Thanks.

[@rambabuy6204]

Thank you. Very helpful.

[@599CD]

You're welcome

[@abrar1945]

how to use between dates in crosstab ? i used this formula but not wotking "Between [Start Date] And [End Date]
"

[@botskie2354]

Thank for your sharing but, How to open a crosstab query with a date range, column head is date instead of state in the cross?

[@599CD]

Feel free to submit your question at 599cd.com/TH

[@farinatty]

Interesting that the invoice date format changes in the non custom field as well. Why did that happen?

[@599CD]

Huh?

[@farinatty]

@@599CD 6:30 you have put a custom format on your YearMonth column. That comes out as expected. However look at the InvoiceDate column. That is now yyyy-mm also.

[@TheGazanews]

great now i understand thank you

[@599CD]

Thanks

[@denizschecter]

Sir I have a question, the same criterias are not working in crosstab queries. İt says access does not recognize the parameters. What is the solution? Could you please help. Thanks a lot

[@599CD]

I would need to see your database to tell you for sure. 599cd.com/SendingMeFiles

[@AbhishekKumar-cq1wy]

Sir how to filter crosstab query by criteria

[@599CD]

599cd.com/Criteria

[@AbhishekKumar-cq1wy]

@@599CD sir thanks for your reply but sir this is not working in cross table query and i have solved by last problem by your support.

[@Bills_Bicycle_Rides]

I'm board....

[@599CD]

Hi board. Nice to meet you. I'm saw.