Basic sums in Access

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


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

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.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"julianp" wrote in message
...

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


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/