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
 

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
Adding columns in a query 2
Change columns into individual records 1
Expression Column Or SQL Query 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Excel Macro to Compare two Columns and write to a third 1

Back
Top