How or where do I use a calculation to generate a Salesmans commis

J

Jimmy Mac

I am trying to write a query or report that will subtract freight charges in
a jobs table from the Invoice fees in the same table. Do I need to have a
field in the table to store the results in that table?

Thanks!
JFM
 
D

Dennis

You should not store calculated valuse in tables. Add a column in a query
based on your table like this
SubCharge: [Invoice Fees] - [Freight Charges]
 
J

jahoobob

Jimmy said:
I am trying to write a query or report that will subtract freight
charges in
a jobs table from the Invoice fees in the same table. Do I need to have
a
field in the table to store the results in that table?

Thanks!
JFM
Click to expand...
I would recommend against it. Store as little info in the table and
let a query, form, or report do the math when needed.
 
J

Jimmy Mac

Thanks Dennis!
I have tried your suggestion in a query and it ask me Invoice Fees?
I want the query to fill in the results for all the records. Do you know
what is wrong with the qcurrent query?


Jim,

Dennis said:
You should not store calculated valuse in tables. Add a column in a query
based on your table like this
SubCharge: [Invoice Fees] - [Freight Charges]

I am trying to write a query or report that will subtract freight charges in
a jobs table from the Invoice fees in the same table. Do I need to have a
field in the table to store the results in that table?

Thanks!
JFM
Click to expand...
Click to expand...
 
J

Jimmy Mac

Thanks Dennis! Once I understood how to enter the Expression corectly. The
query worked exactly as I needed.

Thanks again!
Jim,
 
Top