Comparing Times

[lewando_bria]

Hi there...i am having trouble comparing time values in a query...the values are given from different subforms ... i am trying to make an "assigning" function form for referees...so i need to make sure that only referees that are available for a particular game appear on my selection form....i have provided each game wiht a "Start_Time" value and a "Stop_Time" value....in turn with this...each referee has a "Start_Time" and a "Stop_Time" for when they are available to work....

I am pretty new to access and am not sure how to compare time values....here is the query criteria i put in the start and stop time values for the "availablereferees" query...any help would be greatly appreciated on how to get this thing working....THANKS!


Start_Time

IIf(IsNull([Forms]![AssignmentHorizontal]![qrygames_subform].[Form]![GameID]),", Forms![AssignmentHorizontal]![qryrefsavail_subform].Form![Start_Time]"<=[Forms]![AssignmentHorizontal]![qrygames_subform].[Form]![Start_Time])

Stop_Time

IIf(IsNull([Forms]![AssignmentHorizontal]![qrygames_subform].[Form]![GameID]),", Forms![AssignmentHorizontal]![qryrefsavail_subform].Form![Stop_Time]">=[Forms]![AssignmentHorizontal]![qrygames_subform].[Form]![Stop_Time])