<div>
If you use it for a report then you can use <a href="https://support.microsoft.com/en-us/kb/328320" rel="ugc nofollow">this</a> approach to get the desired result...<br />
If you want it as a query then probably you want to create another query that uses crosstab as its source and manipulate it accordingly.
</div>


If you use it for a report then you can use this [https://support.microsoft.com/en-us/kb/328320] approach to get the desired result...
If you want it as a query then probably you want to create another query that uses crosstab as its source and manipulate it accordingly.

<div>
This is also from Design View please. Thanks.
</div>


This is also from Design View please. Thanks.

<div>
Yes, that is from the query grid.<br />
<br />
if you provide some sample data, I could set it up for you.
</div>


Yes, that is from the query grid.

if you provide some sample data, I could set it up for you.

<div>
The step you offered I can do. Please let me clarify - this will create a separate totals column across the row, but how can I add a separate Grand Total row at the bottom of all rows in the query?<br />
<br />
Hope this makes sense.
</div>


The step you offered I can do. Please let me clarify - this will create a separate totals column across the row, but how can I add a separate Grand Total row at the bottom of all rows in the query?

Hope this makes sense.

<div>
<div class="content wysiwyg-content">
Please offer if there is a way for me to include a Grand Total for the column field in a crosstab quert - Access 2013.<br />
<br />
I am able to calculate totals (based on counts) for rows, but not columns.<br />
<br />
Thank you.
</div>
</div>


Please offer if there is a way for me to include a Grand Total for the column field in a crosstab quert - Access 2013.

I am able to calculate totals (based on counts) for rows, but not columns.

Thank you.

Access - Grand Total Column in Crosstab Query

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.