Query Help

  • Thread starter Thread starter DS
  • Start date Start date
D

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
 
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)
 
KARL said:
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
Click to expand...
Click to expand...
Thanks Karl.
It worked perfectly!
DS
 
Back
Top