Basic sums in Access

  • Thread starter Thread starter julianp
  • Start date Start date
J

julianp

I am a real access simpleton (although improving all the time). I have a
query and subsequent report which has three columns showing - names,
number of items required (using the count function) and number of items
dispatched (also using the count function) I would like to find a way
of showing on the report/query a new column showing the difference i.e.
(items required minus items dispatched)

Preferable using the wizard as I am an SQL Muppet.

Julian
 
SELECT CoName, Count(ItemsRequired) AS CountOfItemsRequired,
Count(ItemsDispatched) AS CountOFItemsDispatched,
Count(ItemsRequired) - Count(ItemsDispatched) AS Difference
FROM YourTable
Group By CoName

I don't know of a wizard that would do that for you. Obviously, you will
have to supply the correct field names and table name.
 
Back
Top