B
Bob Martin
I recently upgraded from Access97 to Access 2003. One of
the features I want to experiment with is Pivot Tables. I
want to create an input form that will display calculated
information when data is inputted. In one of my Access 97
databases, I created a Make Table query to perform a
procedure to select the last meter reading so I can use it
in a report to calculate the difference in the meter
reading for a specific period. What I'd like to do is
perform this calculation right on the input form so the
user can determine the accuracy of the data input
immediately rather that running the make table query and
opening the report.
Is this possible in a Pivot Table?
The formula/expression that was created (with help from
Access VIP's) for use in the Make Table query to select
the previous meter reading is as follows:
PrevReading: (Select Top 1 [Meter_Reading] from
Query_MeterReadings as tq where tq.Order =
Query_MeterReadings.Order And tq.DateRead <
Query_MeterReadings.DateRead Order by tq.DateRead Desc)
I need help revising this expression so it produces the
same results in the input form. I tried cutting and
pasting the formula into the calculation tab of the Pivot
Table view for the test input form and it returns a
#ERROR!. I then tried removing the "PrevReading:" text
from the expression and it again produced the same
#ERROR!. As you can probably tell, I don't know exactly
what this expression does or how it works, but it produces
the correct information.
Any suggestions?
the features I want to experiment with is Pivot Tables. I
want to create an input form that will display calculated
information when data is inputted. In one of my Access 97
databases, I created a Make Table query to perform a
procedure to select the last meter reading so I can use it
in a report to calculate the difference in the meter
reading for a specific period. What I'd like to do is
perform this calculation right on the input form so the
user can determine the accuracy of the data input
immediately rather that running the make table query and
opening the report.
Is this possible in a Pivot Table?
The formula/expression that was created (with help from
Access VIP's) for use in the Make Table query to select
the previous meter reading is as follows:
PrevReading: (Select Top 1 [Meter_Reading] from
Query_MeterReadings as tq where tq.Order =
Query_MeterReadings.Order And tq.DateRead <
Query_MeterReadings.DateRead Order by tq.DateRead Desc)
I need help revising this expression so it produces the
same results in the input form. I tried cutting and
pasting the formula into the calculation tab of the Pivot
Table view for the test input form and it returns a
#ERROR!. I then tried removing the "PrevReading:" text
from the expression and it again produced the same
#ERROR!. As you can probably tell, I don't know exactly
what this expression does or how it works, but it produces
the correct information.
Any suggestions?