unbound control calculation help

[ferde]

I added an unbound control to my form to perform a calculation to determine
the number of hours from time of arrival to time of departure. It worked
great using the following formula in my unbound control as long as both the
arrival and departure dateTimes were from the form field list.

= dateDiff("h"[arr_dateTime],[departTime])

I have changed my form so that the departTime is no longer a bound control
but rather a calculated control . Is it still possible to determine the
difference between arrival time (bound control) and departure time (
calculated control) using this same formula or do I need to learn another
way?

Any direction would be appreciated.
Access 2003

 

[John W. Vinson]

I added an unbound control to my form to perform a calculation to determine
the number of hours from time of arrival to time of departure. It worked
great using the following formula in my unbound control as long as both the
arrival and departure dateTimes were from the form field list.

= dateDiff("h"[arr_dateTime],[departTime])

I have changed my form so that the departTime is no longer a bound control
but rather a calculated control . Is it still possible to determine the
difference between arrival time (bound control) and departure time (
calculated control) using this same formula or do I need to learn another
way?

Any direction would be appreciated.
Access 2003

If it doesn't work (you don't say if you've tried it!), you can use

=DateDiff("h", [arr_dateTime], <the same expression that you use to calculate
the departure date>)