Amalgamating two time fields 2

[logopolis]

I have two time fields time1 and time2. Where time2 has no entries I want to enter time1's data. I have created a NZ function to insert a 0 when there is nothing in time2 and have created the following expression in a blank field. IIf ( [time2] =0, [time1] , [time2] ). When I run the query it comes up with an Error on the fields from Time1 but the time2 data is fine.

Any Ideas.

 

[PHV]

Why not simply a single field ?
Time field: Nz([time2],[time1])

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[logopolis]

I have been so stupid, that is so obvious. Thank you so much for that.