Pushing data on forms (1 Viewer)

[HL]

Can anyone help me!

On a form I have created a number of text boxes and a combo box which sends the date to the table.

Also I have an unbound text box "Actual Down Time" which works out the down time between two times =DateDiff("n",[equipment start time],[equipment stop time]).

The only problem with this, is the information in the unbound text box does not get sent to the table

How do I over come this problem.

Cheers

HL

 

[R. Hicks]

It should not be sent (stored) to the table. If you do, the result becomes "Static". if the start time or stop time should get altered latter somehow, the stored result would not be correct. You should calculate the result "on the fly", the result is then "Dynamic" and the calculated result will always be correct.

HTH
RDH

 

[dkirk02]

I have the same sort of problem. I am working in a form with a "cycle time" field where the default value =Date Stopped-Date Started. I need to have the cabability to query the cycle time for all accounts. I assume this means that the result of the calculation will need to be stored in the table. Is there a way to do this?