Tables&Formulas

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
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Add Data to a table 2
Need Table and Subtable in RDLC 5
Write to an XML file using data from an SQLserver table 2
Calculations in Report Footer 9
ODBC and Excel 1
Excel Macro to Compare two Columns and write to a third 1
Expression Column Or SQL Query 2
Adding columns in a query 2

Top