I am trying to wrap my head around a query that takes like products (based off some identifying field, not the part number it self), and add everything together.
I will try and detail my thoughts here:
Product A has a quantity of (1) and a cost of $2.
Product B has a quantity of (2) and a cost of $4.
Over the life of the job, you add a handful of A's twice. So the first time you add (3) and the second time you add (1). For B, you add (3), but the cost goes up to $5.
Using that, I would want the query to show A as having a total of (5) with its cost of $2, and B would have two entries. One showing the quantity of (2) @ $4 and one showing the quantity of (3) at $5.
I have messed with using "Like" in my queries before, but nothing quite this...robust?
TLDR:
I am trying to make a query for a report to show a running total for a job. It would keep adjusting the quantities, but in the event of a cost change, would show the items quantities for each cost of the item.
I will try and detail my thoughts here:
Product A has a quantity of (1) and a cost of $2.
Product B has a quantity of (2) and a cost of $4.
Over the life of the job, you add a handful of A's twice. So the first time you add (3) and the second time you add (1). For B, you add (3), but the cost goes up to $5.
Using that, I would want the query to show A as having a total of (5) with its cost of $2, and B would have two entries. One showing the quantity of (2) @ $4 and one showing the quantity of (3) at $5.
I have messed with using "Like" in my queries before, but nothing quite this...robust?
TLDR:
I am trying to make a query for a report to show a running total for a job. It would keep adjusting the quantities, but in the event of a cost change, would show the items quantities for each cost of the item.