Concatenating two Time fields

[NeedsHelp101]

Hi,
I'm trying to concatenate two Time fields in a query. Sometimes the second field will be null, so I wrote:
(the lengths are associated with a MasterName)

Duration: Format([tblMasterNames.Length],"Short Time") & ("/"+Format([tblMasterNames_1.Length],"Short Time"))

and in SQL:
Format([tblMasterNames.Length],"Short Time") & ("/"+Format([tblMasterNames_1.Length],"Short Time")) AS Duration

OR

Duration1: IIf([tblISCI].[Master2]=Null,Format([tblMasterNames.Length],"Short Time"),Format([tblMasterNames.Length],"Short Time") & " / " & Format([tblMasterNames_1.Length],"Short Time"))

and in SQL:
 IIf([tblISCI].[Master2]=Null,Format([tblMasterNames.Length],"Short Time"),Format([tblMasterNames.Length],"Short Time") & " / " & Format([tblMasterNames_1.Length],"Short Time")) AS Duration1

No matter what I try, though, if the second field is null,
I will get something like 00:30 /
I need to get rid of the backslash. Can someone help?
Thanks!

 

[PHV]

Don't use
= Null
but
Is Null

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

 

[SkipVought]

Hi,

???

Duration is the difference in two times.

What you seem to be reporting is two time string representations.

So if the two times are 01:00 and 13:30, do you want to report
[tt]
Duration
01:00 / 13:30
[/tt]
???

What does that have to do with Duration?

The Duration is...
[tt]
12:30
[/tt]
which is the ABS(DIFFERNCE) between the two times.

???



Skip,
[sub]
[red][/red]
[/sub]

 

[NeedsHelp101]

Hi Skip,
Thanks for the input- I did want to represent the string, because it was the durations of two things that I wanted to put in the column.
PHV solved the problem for me.