Like numbers in a field

  • Thread starter Thread starter Ralph Kramden
  • Start date Start date
R

Ralph Kramden

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.
 
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.
 
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];
 
Great Infomation!!! You guys really make it seem so simple. Thanks for
information!!!!
 
Back
Top