Trouble in writing a result from a calculation back to a field.

  • Thread starter Thread starter ACE Connection
  • Start date Start date
A

ACE Connection

Hello.

I have made a form where i register some values into 5 fields in a row in a
table. I have an exit trigger that makes a calculation based on the entered
values (skip the higest and the lowest number, and make an avg. on the two
in the middle)
This runs fine in an unbound control in the form.

My problem is that I have to use the result in a report, and find it hard to
make the algoritm in the query.

I would therefore like to put the result back in an empty fileld in the
table in the same row, but struggles.

Can anyone help?

Regards Espen
 
You don't need to save this to a field. In fact, by the normalizations
rules, you shouldn't. If you can calculate it in an unbound control on the
form, you can calculate it in an unbound control of your report. That's
where you should do it.
 
I have tried to do what is suggested, and have put the loop in as Private
Sub Detail_Format in the report.
The loop executes fine, but I cannot get the result out to the report.

How can I get the result out to a control in the report?

-Espen
 
Back
Top