Prev: Display records one time only
Next: DELETE column in TABLE
From: Lnwolf via AccessMonster.com on 16 Mar 2010 15:33
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.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201003/1

From: Jeff Boyce on 16 Mar 2010 17:28
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.

"Lnwolf via AccessMonster.com" <u55964(a)uwe> wrote in message
news:a51b9bf223caf(a)uwe...
>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.
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201003/1
>


 | 
Pages: 1
Prev: Display records one time only
Next: DELETE column in TABLE