Row total based on criteria in Cross Tab Query

[lone_rider15]

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.

 

[JHB]

Open the FinalCrosstab, see if it fullfeed you requirement.

 

[lone_rider15]

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

 

[JHB]

You're welcome, good you got it.