Display information that is based on other fields

[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

[Gary Floam]

Hello Herbert,

It seems that you should create a new table just to hold the quarterly data.
Empty the table before you run the report, call your routine to generate the
quarterly and modify your routine to put the results in your table, and have
the quarterly report based on this new table. The button to run the
quarterly report (I assume it will be called from some screen) will
1. Delete everything from the table left over from the last report.
2. Call the routine to generate the new data,
3. Run the report.

Hope this helps,

Gary

"Herbert Chan" <he*****@chan.com> wrote in message
news:bl*********@rain.i-cable.com...

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