Tables&Formulas

[Trent]

Hi,
I am brain dead about Access, but have managed to set up a
nice SQL database. anyway, I created a table of inventory
for my company. What I am trying to do is subtract to
columns in a table. I.E.
column 1=Product Cost
column 2=Sale Price
column 3=Profit
what I wanted to do is:
column1-column2=profit
so that when a user enters values into column1 and column
to it displays the result in column3 the profit column.
I wish it was as easy as algebra well, I hope you can
help

 

[Gerald Stanley]

You do not need to store the Profit column on your
database. You can show it on any form or report by simply
setting the controlSource of a textbox to
=[Product Cost] - [Sale Price]

Hope This Helps
Gerald Stanley MCSD