J
joe
Hai
Iam trying to develop a database in access for logging flight details for a
flying club and iam using Access 2007
I created a form called LogFlight which has few field like
Date of flight : current date
Wheels OFF Time: take off time of flight in 24 hr format
Wheels ON Time: landing time of flight in 24 hr format
DURATION: A calculated field using expression in control sourse
=DateDiff("n",[WheelsOffTime],[WheelsOnTime])
And a Save Button
I would like to save all these 3 field into a table called Account Table
having all of these 3 fields i tried but the field of Duration is showing
blank.
Is there any way to do this ??????
Thanks in Advance...........
Iam trying to develop a database in access for logging flight details for a
flying club and iam using Access 2007
I created a form called LogFlight which has few field like
Date of flight : current date
Wheels OFF Time: take off time of flight in 24 hr format
Wheels ON Time: landing time of flight in 24 hr format
DURATION: A calculated field using expression in control sourse
=DateDiff("n",[WheelsOffTime],[WheelsOnTime])
And a Save Button
I would like to save all these 3 field into a table called Account Table
having all of these 3 fields i tried but the field of Duration is showing
blank.
Is there any way to do this ??????
Thanks in Advance...........