Your post seems to contain contradictory statements. On the one hand you say:
"Each records is distinct when looking at Part#, Sales Order#, and Serial#
together"
On the other hand you ask:
"Does anyone know how to run the query that will net those items that are
alike in 3 different fields?"
If the first is true then, assuming Part#, Sales Order#, and Serial# are the
three columns in question (and I can't see what else they can be), the second
makes no sense as the aggregation would be of values in one row only in each
case.
Perhaps the best way to clarify this would be to post some samples of rows
from the table, including all columns, not just those to be returned by the
query, and an example of the rows you'd wish the query to return from that
sample data.
Ken Sheridan
Stafford, England
SandyG wrote:
>I have created a movement table for serialized parts. parts are used
>multiple times. As such, i'll have repeat records for the same parts/serial
>number. I have not been able to run a query to group the net change in part
>movements. The query returns each movement and does not summarize even when
>I request a totals - sum by query.
>Details:
>PART 1 SALES ORDER 123 QTY 1 VALUE $100
>PART 1 SALES ORDER 123 QTY -1 VALUE -$100
>My query request to return only those (net) that have a QTY not equal to 0.
>My table does not have any keys as duplicate records should be allowed.
>Each records is distinct when looking at Part#, Sales Order#, and Serial#
>together.
>I attempted to create a multiple key and requested that duplciate be allowed.
>However, received an error message.
>Does anyone know how to run the query that will net those items that are
>alike in 3 different fields?
>Thank you !
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access/200911/1
|
