Two Crosstab with one total

  • Thread starter Thread starter Nick
  • Start date Start date
N

Nick

I am trying to get a running total on figures but am unable to do so. I can
get them to show up on a query but unable to understand how they can be added
together. Your help is appreciated.
SELECT OvertimeTracking_CrosstabodlTOTAL.Mon,
OvertimeTracking_CrosstabodlTOTAL.Sat, qOT.Prior
FROM qOT INNER JOIN OvertimeTracking_CrosstabodlTOTAL ON qOT.SSI =
OvertimeTracking_CrosstabodlTOTAL.SSI;
 
What are you trying to total. I see two fields from the same query(?) being
displayed but no attempt at doing any math.
 
Sorry,add OvertimeTracking_CrosstabodlTOTAL.Sat with qOT.Prior. I tried
adding + sign between them and naming it weekTotal. but received and error
message.
 
Back
Top