<div>
Select Title, [Status One], [Status Two], [Status Three], ([Status One] + [Status Two] + [Status Three]) As Total FROM tblMain<br />
<br />
Is this what you want?<br />
OM Gang
</div>


Select Title, [Status One], [Status Two], [Status Three], ([Status One] + [Status Two] + [Status Three]) As Total FROM tblMain

Is this what you want?
OM Gang

<div>
i did not get, &nbsp;no, i do not want that<br />
what if i have fifty different statuses, ?
</div>


i did not get,  no, i do not want that
what if i have fifty different statuses, ?

<div>
try this<br />
<br />
select title,[count] from tblMain<br />
union<br />
select 'Total' as title, sum([count]) from tblMain
</div>


try this

select title,[count] from tblMain
union
select 'Total' as title, sum([count]) from tblMain

<div>
That is what i was thinking, you use two queries and union them, I did that...<br />
It is working...<br />
is there just one select query?
</div>


That is what i was thinking, you use two queries and union them, I did that...
It is working...
is there just one select query?

<div>
You cannot get there from here. &nbsp;- ie. &nbsp;without using a union query ;-)
</div>


You cannot get there from here.  - ie.  without using a union query ;-)

<div>
<div class="content wysiwyg-content">
I have a simple table tblMain<br />
Title &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Count<br />
Status One &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2<br />
Status Two &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3<br />
Status Three &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1<br />
so to get the select statement :) &nbsp; you go <br />
select * from tblMain<br />
<br />
i want to modify the query and include the grandtotal also , so the results should be :<br />
<br />
Title &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Count<br />
Status One &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2<br />
Status Two &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3<br />
Status Three &nbsp; &nbsp; &nbsp; &nbsp; 1<br />
Total &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 6<br />
<br />
it is simple to use two queries and then combine using union query<br />
I need it as one query<br />

</div>
</div>


I have a simple table tblMain
Title                       Count
Status One           2
Status Two          3
Status Three          1
so to get the select statement :)   you go 
select * from tblMain

i want to modify the query and include the grandtotal also , so the results should be :

Title                       Count
Status One           2
Status Two          3
Status Three         1
Total                     6

it is simple to use two queries and then combine using union query
I need it as one query


Please modify my exisitng 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.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.