merc123
Senior Member
Been a while since I used databases (think 2002) and trying to figure this out.
I have a table that has order numbers, price, quantity and tax rate. I am breaking down the parts within the order so I may have 5 parts with the same order number and different prices/quantitys. I have a form that shows the info based off a query of said table. What I want to do is get a total dollar amount for the order number. Like this:
Order #: 1
Price: $5
Quantity: 1
Tax Rate: 7%
Order #: 1
Price: $2
Quantity: 2
Tax Rate: 7%
Order #: 1
Price $10
Quantity: 1
Tax Rate: 7%
Order #2
Price: $5
Quantity: 10
Tax Rate: 7%
The order total for order #1 should show $18.19 in the field "Total for Order" and not include Order #2. How would I do that.
I have a table that has order numbers, price, quantity and tax rate. I am breaking down the parts within the order so I may have 5 parts with the same order number and different prices/quantitys. I have a form that shows the info based off a query of said table. What I want to do is get a total dollar amount for the order number. Like this:
Order #: 1
Price: $5
Quantity: 1
Tax Rate: 7%
Order #: 1
Price: $2
Quantity: 2
Tax Rate: 7%
Order #: 1
Price $10
Quantity: 1
Tax Rate: 7%
Order #2
Price: $5
Quantity: 10
Tax Rate: 7%
The order total for order #1 should show $18.19 in the field "Total for Order" and not include Order #2. How would I do that.