Recent content by Abi

OK thx a lot! I'm new to VBA in access, I had some experience with VBA long ago but ... it's all gone. Now I'm having the next problem in creating my database. As the values of the field "Total Time" in the form are calculated, it seems not possible to make a sum of it in the footer of the...

Ok it works when I put this directly into the control source: =NZ( [Flight Time] )+NZ( [Arrival Time] - [Departure Time] ) But I don't manage to do this via the module. Could someone give me an example of a module to do this? I get external name not defined when compiling this: "Option...

Thx, I've tried this but then I get 0:00 as elapsed time for every record. Public Function totaltime() Dim interval As Date If IsNull(ArrivalTime) = True Then interval = FlightTime Else interval = ArrivalTime - DepartureTime End If totaltime = interval End Function So, when I put...

Hi, I've been trying to calculate elapsedtime between two fields in a database. I have field1 and field2 in short time format and the easy way "field2-field1" gives me the correct elapsed time in the short time format in a new field in my form. But for some records I don't have the data to...