Calculated Field on a form

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

Guest

Hello,
I have a form, bound to a table, with a calculated field on it. This
particular field displays the last date that data is contained in the table
for. The control source is:

=Max([tblActiveData]![Expiration])

This works fine but, as the table gets larger, it takes longer and longer
for the field to calculate when the form is opened. It's now over a minute
and a half, which seems like an eternity when you can't do anything. I'm
looking for another way to accomplish this, but without the long calculation
time. I've tried writing the date to a separate table, but I get "#NAME?" in
the field when I try to use a record from a table other than the table the
form is bound to.

Any suggestions would be greatly appreciated.

Thanks to all.
 
mikelee101 said:
Hello,
I have a form, bound to a table, with a calculated field on it. This
particular field displays the last date that data is contained in the
table for. The control source is:

=Max([tblActiveData]![Expiration])

This works fine but, as the table gets larger, it takes longer and
longer for the field to calculate when the form is opened. It's now
over a minute and a half, which seems like an eternity when you can't
do anything. I'm looking for another way to accomplish this, but
without the long calculation time. I've tried writing the date to a
separate table, but I get "#NAME?" in the field when I try to use a
record from a table other than the table the form is bound to.

Any suggestions would be greatly appreciated.

Thanks to all.
Click to expand...

Does the [Expiration] field have an idex on it? If it does the default for
an index is ascending order. It might speed things up if you changed it to
descending order. No reason that kind of call shouldn't be almost
immediate.
 
Back
Top