Discussion Locked

Project

0 helpful
7 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have this project in which I have to use Microsoft Access or Excel to impliement.

I have computer products and what a progarmm that
updates the sales of a product.eg. if have 200 64MB of RAMS and I sell say 2, the programm will minus 2 from 200 and update the number remaing.

7 replies

by timthetoolman

Hi,

Your question is very unclear. Do you want us to write the system for you?

What you seem to be asking for is basic coding. If you're unsure about it, then I suggest you take a tutorial...

Tim.

by maxwell edison

Excel provides several methods for creating running totals. You can use a worksheet function like =SUM($A$1:A1) where the values to total (or subtract) are in column A and the formula is copied down column B.

See this link for a full explanation, illustrations, and some code that could be downloaded.

http://lacher.com/examples/lacher03.htm

Also see this link:

http://saturn.fab.albany.edu/ulans/excelTips.htm

"Create a Formula to Keep a Running Total in Excel"

In Microsoft Excel, you can calculate a running (or cumulative) total in a column or row of cells by using a combination of absolute and relative references in a formula that uses the SUM function.

>> REMOVE SPACES from the pasted URLs <<

Maxwell

This discussion is closed to new replies.