Prev: Reminder - Microsoft Responds to the Evolution of Community
Next: memo field size
From: Ralph Kramden on 20 May 2010 11:34
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.
From: RonaldoOneNil on 20 May 2010 11:45
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.
From: KARL DEWEY on 20 May 2010 11:48
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.
From: KenSheridan via AccessMonster.com on 20 May 2010 12:02
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/Forums.aspx/access/201005/1

From: Ralph Kramden on 20 May 2010 14:27
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.
 | 
Pages: 1
Prev: Reminder - Microsoft Responds to the Evolution of Community
Next: memo field size