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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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]
 
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...
 
Thanks Dennis! Once I understood how to enter the Expression corectly. The
query worked exactly as I needed.

Thanks again!
Jim,
 
Back
Top