D
Devon
I am attempting to create a report that can sort through
the data on a table. This table and report will have
numerous columns, but the only ones I am struggling with
are as follows: [traderate], [daylow], and [dayhigh].
Basically this data tells me what something was traded at
(traderate) and then what that days low and high were. If
the trade rate is between the low and the high, then all
is good. If it is above or below, more research is
needed. There is a seperate column in the report that
lists if the record has an error (traderate is outside the
range from daylow to dayhigh), so I can easily eliminate
all 'good' records that don't need further research.
What I specifically need is a formula that will tell me
how much too high or too low the trade rate is so that we
can then decide if we want to look at all the 'error'
records, or only those that fall outside a parameter we
will later set. For example, if TradeRate = 5 and DayLow
= 7 and DayHigh = 9, I want the formula to tell me -2.
I am assuming that in the report I would put a formula in
an unbound text box, and then use the expression builder
within the unbound text boxes properties control source,
but am not sure what the formula needs to look like since
the rate can be high or low, and the daylow and dayhigh
are going to vary from day to day.
Hope this makes sense.
Thanks in advance.
the data on a table. This table and report will have
numerous columns, but the only ones I am struggling with
are as follows: [traderate], [daylow], and [dayhigh].
Basically this data tells me what something was traded at
(traderate) and then what that days low and high were. If
the trade rate is between the low and the high, then all
is good. If it is above or below, more research is
needed. There is a seperate column in the report that
lists if the record has an error (traderate is outside the
range from daylow to dayhigh), so I can easily eliminate
all 'good' records that don't need further research.
What I specifically need is a formula that will tell me
how much too high or too low the trade rate is so that we
can then decide if we want to look at all the 'error'
records, or only those that fall outside a parameter we
will later set. For example, if TradeRate = 5 and DayLow
= 7 and DayHigh = 9, I want the formula to tell me -2.
I am assuming that in the report I would put a formula in
an unbound text box, and then use the expression builder
within the unbound text boxes properties control source,
but am not sure what the formula needs to look like since
the rate can be high or low, and the daylow and dayhigh
are going to vary from day to day.
Hope this makes sense.
Thanks in advance.