Row total based on criteria in Cross Tab Query (1 Viewer)

Hello Everyone,

Is there any way to get row total based on criteria in a cross tab query? I am using MS Access 2013. I created a cross tab query. I need seven column with row count based on some criteria. I created 7 queries with the criteria. When I join them all with cross tab query it does not return any record:banghead:.

I have attached my sample database and an excel sheet which shows how I want the final result of my query.

Hope somebody can point me to the right direction.

Thanks in advance.

Open the FinalCrosstab, see if it fullfeed you requirement.

Sorry for the late response. Thanks a lot. That did the trick. I was able to do the rest myself.

You're welcome, good you got it.