Tables&Formulas

  • Thread starter Thread starter Trent
  • Start date Start date
T

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
 
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
 
Back
Top