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
|
|||
|
|||
Like numbers in a field
I am working with a 25,000 row parts issue listing that was created by parts
issue date. There are many repeat numbers in the part number column as the same part would have been issued on several different dates. I would like to be able to combine the like part numbers to know how many parts were issued over the course of all of the dates. Any ideas??? The Column headers are Part Number, Quantity, Unit Price, Total Price and Transaction Date. |
#2
|
|||
|
|||
Like numbers in a field
Create a new query based on your parts issue listiong table. Drag the Part
number field into the query grid twice. Click on the Totals button, (the greek sigma icon on the toolbar). Leave the first part number in your query as Group By, but change the 2nd one to count. Run the query. "Ralph Kramden" wrote: I am working with a 25,000 row parts issue listing that was created by parts issue date. There are many repeat numbers in the part number column as the same part would have been issued on several different dates. I would like to be able to combine the like part numbers to know how many parts were issued over the course of all of the dates. Any ideas??? The Column headers are Part Number, Quantity, Unit Price, Total Price and Transaction Date. |
#3
|
|||
|
|||
Like numbers in a field
Try this --
SELECT [Part Number], Sum([Quantity]) AS Total FROM YourTable WHERE [Transaction Date] Between CVDate([Enter start date]) AND CVDate([Enter end date]) GROUP BY [Part Number]; -- Build a little, test a little. "Ralph Kramden" wrote: I am working with a 25,000 row parts issue listing that was created by parts issue date. There are many repeat numbers in the part number column as the same part would have been issued on several different dates. I would like to be able to combine the like part numbers to know how many parts were issued over the course of all of the dates. Any ideas??? The Column headers are Part Number, Quantity, Unit Price, Total Price and Transaction Date. |
#4
|
|||
|
|||
Like numbers in a field
To get the total of all quantities per part issued you need to group the
query by Part Number and Sum the Quantity column. In SQL it would look like this: SELECT [Part Number], SUM([Quantity]) AS [Number Issued] FROM [YourTableNameGoesHere] GROUP BY [Part Number]; Ken Sheridan Stafford, England Ralph Kramden wrote: I am working with a 25,000 row parts issue listing that was created by parts issue date. There are many repeat numbers in the part number column as the same part would have been issued on several different dates. I would like to be able to combine the like part numbers to know how many parts were issued over the course of all of the dates. Any ideas??? The Column headers are Part Number, Quantity, Unit Price, Total Price and Transaction Date. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ccess/201005/1 |
#5
|
|||
|
|||
Like numbers in a field
Great Infomation!!! You guys really make it seem so simple. Thanks for
information!!!! "Ralph Kramden" wrote: I am working with a 25,000 row parts issue listing that was created by parts issue date. There are many repeat numbers in the part number column as the same part would have been issued on several different dates. I would like to be able to combine the like part numbers to know how many parts were issued over the course of all of the dates. Any ideas??? The Column headers are Part Number, Quantity, Unit Price, Total Price and Transaction Date. |
Thread Tools | |
Display Modes | |
|
|