H
Herbert Chan
Hello,
I have a table that stores information about some yearly forecast output,
and a form that shows the records.
Recently, my boss wants to show the data on a quarterly basis. Although the
table doesn't actually store the quarterly forecast, I have an algorithm
that can generate such a forecast.
The problem is: how to do the generation on the fly when I use the form to
show the records? The expression is not a simply expression like Y2000/4. I
need to do a few comparisons between consecutive years and then determine
how to break the yearly forecast down to quarterly forecast.
Is there any way to tell the access form to do the calculation maybe like
with vba and then show the results? I'll need to use data in the table that
are not shown on the form.
Thanks
Herbert
I have a table that stores information about some yearly forecast output,
and a form that shows the records.
Recently, my boss wants to show the data on a quarterly basis. Although the
table doesn't actually store the quarterly forecast, I have an algorithm
that can generate such a forecast.
The problem is: how to do the generation on the fly when I use the form to
show the records? The expression is not a simply expression like Y2000/4. I
need to do a few comparisons between consecutive years and then determine
how to break the yearly forecast down to quarterly forecast.
Is there any way to tell the access form to do the calculation maybe like
with vba and then show the results? I'll need to use data in the table that
are not shown on the form.
Thanks
Herbert