Query Help

[DS]

I have a Query. It has a StartTime and an EndTime field. Both Fields
are Date/Time Type. I made an expression that reads...

Expr1:=IIf([EndTime]<[StartTime],[After]=-1,[After]=0)

The After field is a Checkbox, essentially I want the CheckBox to be
checked if the EndTime is less than the StartTime. This doesn't seem to
be working any help appreciated.

Thanks
DS

 

[Guest]

You need to use an Update Query with this in the Update row of the design
view grid of the [After] field.
IIf([EndTime]<[StartTime],-1,0)

 

[DS]

You need to use an Update Query with this in the Update row of the design
view grid of the [After] field.
IIf([EndTime]<[StartTime],-1,0)

:

I have a Query. It has a StartTime and an EndTime field. Both Fields
are Date/Time Type. I made an expression that reads...

Expr1:=IIf([EndTime]<[StartTime],[After]=-1,[After]=0)

The After field is a Checkbox, essentially I want the CheckBox to be
checked if the EndTime is less than the StartTime. This doesn't seem to
be working any help appreciated.

Thanks
DS

Thanks Karl.
It worked perfectly!
DS