If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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/ |
#2
|
|||
|
|||
Basic sums in Access
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/ |
Thread Tools | |
Display Modes | |
|
|