Summing the Same field on a report twice

[TonyLackey]

Hi,

Sorry of this is a daft question but I’m not a regular user of Access.

I have a requirement to sum a Value on a report twice, based on two different criteria and I’m not sure how to go about it. Have tried creating two queries but Access won't let me use both of them on the same report

Apologies if i offend experts with this basic question.

Any help / pointers would be appreciated


Tony

 

[boblarson]

What are your criteria?

 

[TonyLackey]

The criteria is a value on another field, i.e 1-6

 

[boblarson]

The criteria is a value on another field, i.e 1-6

Okay, let's try this instead. What would the SQL strings be for each of the queries you want to use?

 

[TonyLackey]

SELECT DISTINCTROW Format$([amos_WorkOrder].[DueDate],'mmmm yyyy') AS [DueDate By Month], Count(amos_WorkOrder.WONo) AS [OverDue WO]
FROM amos_WorkOrder
GROUP BY Format$([amos_WorkOrder].[DueDate],'mmmm yyyy'), amos_WorkOrder.WOStatus
HAVING (((Format$(amos_WorkOrder.DueDate,'mmmm yyyy')) Is Not Null) And ((amos_WorkOrder.WOStatus)=6));


SELECT DISTINCTROW Format$([amos_WorkOrder].[DueDate],'mmmm yyyy') AS [DueDate By Month], Count(amos_WorkOrder.WONo) AS [OverDue WO]
FROM amos_WorkOrder
GROUP BY Format$([amos_WorkOrder].[DueDate],'mmmm yyyy'), amos_WorkOrder.WOStatus
HAVING (((Format$(amos_WorkOrder.DueDate,'mmmm yyyy')) Is Not Null) And ((amos_WorkOrder.WOStatus)=4));