Time Value from form is not displayed on table

[Guest]

I have a simple Access database to track admission criteria for patients. On
my form there is Arrival Time, formatted as short time, Time to Room, also
short time,and Wait Time, again short time format. In design view I have the
expression =[Time to Room]-[Arrival Time] in the Wait Time control source.
This returns hours and minutes on the form itself, but no value is returned
in the table.
Any ideas? I've tried to find info pertaining to this and came up empty, but
I too new at this to know what to look for...
Thanks for any help

 

[Tony Williams]

Calculated values are not stored in tables. You have to calculate the value
on each form/report
HTH
Tony

 

[Guest]

The value in hours and minutes is calculated on the form and functions
correctly. What I am trying to do is get the result from the expression on
the form to be entered in the Wait Time field on the table. Currently this
field remains blank even though the forms corresponding field displays the
result. Is there a way to send the result from the form to the table without
entering it manually? Shouldn't this happen automatically?

Calculated values are not stored in tables. You have to calculate the value
on each form/report
HTH
Tony

I have a simple Access database to track admission criteria for patients.
On
my form there is Arrival Time, formatted as short time, Time to Room, also
short time,and Wait Time, again short time format. In design view I have
the
expression =[Time to Room]-[Arrival Time] in the Wait Time control
source.
This returns hours and minutes on the form itself, but no value is
returned
in the table.
Any ideas? I've tried to find info pertaining to this and came up empty,
but
I too new at this to know what to look for...
Thanks for any help

 

[Pieter Wijnen]

No need to store it, as you can calculate it anytime you need it.

Pieter

The value in hours and minutes is calculated on the form and functions
correctly. What I am trying to do is get the result from the expression on
the form to be entered in the Wait Time field on the table. Currently this
field remains blank even though the forms corresponding field displays the
result. Is there a way to send the result from the form to the table
without
entering it manually? Shouldn't this happen automatically?

Calculated values are not stored in tables. You have to calculate the
value
on each form/report
HTH
Tony

I have a simple Access database to track admission criteria for
patients.
On
my form there is Arrival Time, formatted as short time, Time to Room,
also
short time,and Wait Time, again short time format. In design view I
have
the
expression =[Time to Room]-[Arrival Time] in the Wait Time control
source.
This returns hours and minutes on the form itself, but no value is
returned
in the table.
Any ideas? I've tried to find info pertaining to this and came up
empty,
but
I too new at this to know what to look for...
Thanks for any help

 

[Bob Quintal]

The value in hours and minutes is calculated on the form and
functions correctly. What I am trying to do is get the result from
the expression on the form to be entered in the Wait Time field on
the table. Currently this field remains blank even though the
forms corresponding field displays the result. Is there a way to
send the result from the form to the table without entering it
manually? Shouldn't this happen automatically?

It should not happen automatically, because there should be no wait
time in the table. Wait time is always going to be the difference in
your two other times, and can be calculated on any form, report or
query when needed.

The only place you cannot see the wait time is directly in the
table, and good design practice says you never let a user see a
table, only forms and reports.

Q

Calculated values are not stored in tables. You have to calculate
the value on each form/report
HTH
Tony

I have a simple Access database to track admission criteria for
patients. On
my form there is Arrival Time, formatted as short time, Time to
Room, also short time,and Wait Time, again short time format.
In design view I have the
expression =[Time to Room]-[Arrival Time] in the Wait Time
control source.
This returns hours and minutes on the form itself, but no value
is returned
in the table.
Any ideas? I've tried to find info pertaining to this and came
up empty, but
I too new at this to know what to look for...
Thanks for any help