Adding a row to the query (1 Viewer)

[maravinds]

hallo everyone,

i have the following query and i am getting the following output

SELECT Sum(tbl_RFQ_Details_AVOB.[AVOB RFQ]) AS [SumOfAVOB RFQ], tbl_Status.Status
FROM tbl_Status LEFT JOIN tbl_RFQ_Details_AVOB ON tbl_Status.ID = tbl_RFQ_Details_AVOB.Status
GROUP BY tbl_Status.Status, tbl_RFQ_Details_AVOB.Status;


SumOfAVOB RFQ Status
16900110 RFQ in Process
12610000 Under Review
1200000 Decided
3500000 Terminated
1000000 Terminated Supplier
6000000 Leverage Back
40000000 Uncompetitive
500000 RFQ in Preparation


Now i require a new line in addition to this that says that the total value is and the sum of those values must be given.

required output:

SumOfAVOB RFQ Status
16900110 RFQ in Process
12610000 Under Review
1200000 Decided
3500000 Terminated
1000000 Terminated Supplier
6000000 Leverage Back
40000000 Uncompetitive
500000 RFQ in Preparation
totalvalue Total RFQ

How can this be done?

regards,
aravind.s

 

[*Pete*]

I don't think that you can add that to the query, the best option is to create a form or Report based on your query and do the sum in that.

Regards

Pete