Setting up a criteria

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

Guest

In setting up a criteria in access queries, I have 3 columns one says pre-op
Ave K's the other is Post-op Ave K's and the last is Steepening. What I want
is Post-op K's minus Pre-op K's to give me the Steepening result. But when I
go to "build" the criteria it comes up blank. Can you help me build the
expression?
 
You should remove Steepening from your table because it is a calculated
value. Any time you need that value, it can be calculated on the fly. For
example, in your query, add this expression in a blank field:
Steepening:[Ave K] - [PreOp K]
 
In the last column, you would put...

Steepening: [Post-op K] - [Pre-op K]

Note that Steepening would not be a field in your table. You do not store
calculated results like this in a table since it would be duplicated effort.
When you need to use it in a query, for, or report, you would just calculate
it using the above formula.

Rick B
 
Back
Top