Okay, I'm a bit new to Access development, and I'm wondering if this is possible to have returned as a query. I know how I can do it in a Report, but a Query would be better for later manipulation and data analysis.
What I have is something along the along the lines of the following:
Company CODE Title Quantity Amount
ACA 01 Book Title 1 1 $10.00
ABD 01 Book Title 1 1 $10.00
AZF 01 Book Title 1 1 $10.00
APO 01 Book Title 1 1 $10.00
ADF 01 Book Title 1 1 $10.00
What I would like is to have a Query that returns it in the following fashion:
Code Title Quantity Amount
01 Book Title 1 5 $50.00
Is this even possible with a Query in Access?
What I have is something along the along the lines of the following:
Company CODE Title Quantity Amount
ACA 01 Book Title 1 1 $10.00
ABD 01 Book Title 1 1 $10.00
AZF 01 Book Title 1 1 $10.00
APO 01 Book Title 1 1 $10.00
ADF 01 Book Title 1 1 $10.00
What I would like is to have a Query that returns it in the following fashion:
Code Title Quantity Amount
01 Book Title 1 5 $50.00
Is this even possible with a Query in Access?