Union Query Totals Row?

[Sketchin]

Hi All, I have a union query with the following SQL:

SELECT tblReservations.DateOutReq, tblReservations.DateInReq, tblBOM_Master.BOMDescription, Sum(DateDiff("d",[DateOutReq],[DateInReq])+1) AS [Total Usage Days], tblReservations.ReservationNumber
FROM tblReservations INNER JOIN (tblBOM_Master INNER JOIN tblReservation_details ON tblBOM_Master.BOMID = tblReservation_details.BOMNumber) ON tblReservations.ReservationID = tblReservation_details.ReservationID
GROUP BY tblReservations.DateOutReq, tblReservations.DateInReq, tblBOM_Master.BOMDescription, tblReservations.ReservationNumber, tblReservations.FiscalDateOut, tblReservations.FiscalDateIn, tblBOM_Master.BOMID
HAVING (((tblReservations.DateOutReq)>=[Forms]![frmMetricsMenu]![txtFiscalYearstart] And (tblReservations.DateOutReq)<=[Forms]![frmMetricsMenu]![txtFiscalYearEnd]) AND ((tblReservations.DateInReq)<=[Forms]![frmMetricsMenu]![txtFiscalYearEnd]))
UNION ALL
SELECT tblReservations.DateOutReq, tblReservations.DateInReq, tblBOM_Master.BOMDescription, Sum(DateDiff("d",[DateOutReq],([Forms]![frmMetricsMenu]![txtFiscalYearEnd]))+1) AS [Total Usage Days], tblReservations.ReservationNumber
FROM tblReservations INNER JOIN (tblBOM_Master INNER JOIN tblReservation_details ON tblBOM_Master.BOMID = tblReservation_details.BOMNumber) ON tblReservations.ReservationID = tblReservation_details.ReservationID
GROUP BY tblReservations.DateOutReq, tblReservations.DateInReq, tblBOM_Master.BOMDescription, tblReservations.ReservationNumber, tblReservations.FiscalDateOut, tblReservations.FiscalDateIn, tblBOM_Master.BOMID
HAVING (((tblReservations.DateOutReq)<=[Forms]![frmMetricsMenu]![txtFiscalYearEnd] And (tblReservations.DateOutReq)>[Forms]![frmMetricsMenu]![TxtFiscalYearStart]) AND ((tblReservations.DateInReq)>=[Forms]![frmMetricsMenu]![txtFiscalYearEnd] And (tblReservations.DateInReq)<=DateAdd("d",365,[DateOutReq])))
UNION ALL
SELECT tblReservations.DateOutReq, tblReservations.DateInReq, tblBOM_Master.BOMDescription, 365 AS [Total Usage Days], tblReservations.ReservationNumber
FROM tblReservations INNER JOIN (tblBOM_Master INNER JOIN tblReservation_details ON tblBOM_Master.BOMID = tblReservation_details.BOMNumber) ON tblReservations.ReservationID = tblReservation_details.ReservationID
GROUP BY tblReservations.DateOutReq, tblReservations.DateInReq, tblBOM_Master.BOMDescription, tblReservations.ReservationNumber, tblReservations.FiscalDateOut, tblReservations.FiscalDateIn, tblBOM_Master.BOMID
HAVING (((tblReservations.DateOutReq)<=[Forms]![frmMetricsMenu]![txtFiscalYearStart]) AND ((tblReservations.DateInReq)>[Forms]![frmMetricsMenu]![txtFiscalYearEnd]))
UNION ALL
SELECT tblReservations.DateOutReq, tblReservations.DateInReq, tblBOM_Master.BOMDescription, Sum(DateDiff("d",([Forms]![frmMetricsMenu]![txtFiscalYearstart]),[DateInReq])+1) AS [Total Usage Days], tblReservations.ReservationNumber
FROM tblReservations INNER JOIN (tblBOM_Master INNER JOIN tblReservation_details ON tblBOM_Master.BOMID = tblReservation_details.BOMNumber) ON tblReservations.ReservationID = tblReservation_details.ReservationID
GROUP BY tblReservations.DateOutReq, tblReservations.DateInReq, tblBOM_Master.BOMDescription, tblReservations.ReservationNumber, tblReservations.FiscalDateOut, tblReservations.FiscalDateIn, tblBOM_Master.BOMID
HAVING (((tblReservations.DateOutReq)<=[Forms]![frmMetricsMenu]![TxtFiscalYearStart]) AND ((tblReservations.DateInReq)>=[Forms]![frmMetricsMenu]![txtFiscalYearstart] And (tblReservations.DateInReq)<=[Forms]![frmMetricsMenu]![txtFiscalYearEnd]) AND ((tblReservations.FiscalDateOut)<>[FiscalDateIn]));

After each Item in the query, I have a Total Days Used field that is derived from a DateDiff function.

I am wondering how I would get a grand total at the bottom of the query using all the data from the [Total Days Used] field.

Thanks

 

[Sketchin]

Nevermind, I see that I can just do the total on my Report!

Thanks anyway!