Total column in Query

[Lnwolf via AccessMonster.com]

I have a table with ID, Description, Intake, Sold, Remaining, Intake Date, &
Total Inventory.

I would like to have the Total Inventory column populate with a total from
remaining column based on the description.

For example: At the beginning of February I took in a total of 5 warmers.
During the month of February I sold 4 of those warmers. Leaving a remaining
total for February of 1.

At the beginning of March I took in 5 more warmers.. for a total inventory of
6... if I sold 3 in March I would like the Total inventory to show 3 at the
end of March....

Am I making myself clear??? I want a seperate column that totals the
remaining inventory by description.

 

[Jeff Boyce]

Access queries retrieve data ... but they don't do what you're describing.

For that, take a look at Access Reports.

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.