Create a Crosstab Query in Access

Create a crosstab query in Access to analyze numerical data by multiple categories. This example looks at total billable work performed by employees for several different types of work performed.

[@stanTrX]

Can you show concaeted text for results, instead of a calculation?

[@evaldasilginis3119]

Exactly what I was looking for. Thank you.

[@sparsecass]

Extremely helpful, Thank you

[@ErikHelland]

I successfully built multiple queries. The non-crosstab queries that I grouped by month automatically add a new month whenever new data comes in...however the crosstab query is still a snapshot from two months ago....why isnt it updating? Am I missing something simple?? Thanks!

[@jeevankg]

can you show how to do an average in cross tab report

[@Metal_Hed]

Very good explanations and walk through.

[@sirwanjaf9016]

it was helpful. thanks

[@BarbHendersonconsulting]

Great video thanks

[@kelayang]

helpful. thank you

[@trilailla5777]

THANKYOUUU

[@norzeemnorzeem4586]

excellent!

[@edgarsan71991]

and now how do you filter de info

[@youssefjalal2191]

HOW TO CREATE TIME IN ACCESS THANK YOU

[@drallisimo34]

great!!!

[@taslimsuman]

nice

[@rafikiplays9273]

how is everybondy doing lololol dab on haters

[@manavshahh6677]

bakchodi kam kro bhaiya

[@dodojhon2051]

you talk too much

[@SixMinutesSmarter]

Are you my ex wife?