Difficult timing Issue - with start & stop times and calculations

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

Guest

I am trying to make a billing form for a DB I am trying to design that does
not seem to work.

I has four time sections availible, [4 X ( EndTime - StartTime)]. I then
want to calculate the agregate of those 4 resulting times to give a
TotalTableTime. I have been able to do this by building an expression the
the Properties - control box, however, I need to be able to have the
calculated result entered into my Billing table. This makes it so that I
need to make my "TotalTableTime" field bound to the table instead of an
unbound textbox.
I have tried to enter the calculating expressing into the Properties -
default value box, but I get an error.

Is there a way to have a bound textBox with an expression in the control box?

I also want to make it to the StartTime and EndTime boxes can be auto fill
with the current time. I have tried to setup "On Dbl Click...." expression
using "Now()" and setting the input mask as "Short Time" but nothing happens.

If you can help on any of these issue Thank You.
 
First I have to say that its wrong to save a calculated field in your DB
But if you want to any way, then mybe live your field unbound as you all
ready did.
create another text box that is not visible on your form bounded to your
field.
 
Back
Top