Hello,
I have a Microsoft Access query that has a column “Piece Price”. I would like to get a total in a separate column of the total for all of the total pieces per work order. See sample below.
Sample:
WO # Piece Price Total Price
WO3333 $200.00 $1,000.00
WO3333 $700.00 $1,000.00
WO333 $100.00 $1,000.00
Thank you for your help.
I have a Microsoft Access query that has a column “Piece Price”. I would like to get a total in a separate column of the total for all of the total pieces per work order. See sample below.
Sample:
WO # Piece Price Total Price
WO3333 $200.00 $1,000.00
WO3333 $700.00 $1,000.00
WO333 $100.00 $1,000.00
Thank you for your help.