Query Help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DS - 28 Jun 2006 21:43 GMT

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

Reply to this Message

KARL DEWEY - 28 Jun 2006 21:53 GMT

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...
[quoted text clipped - 7 lines]
> Thanks
> DS

Reply to this Message

DS - 29 Jun 2006 02:41 GMT

> You need to use an Update Query with this in the Update row of the design
> view grid of the [After] field.
[quoted text clipped - 11 lines]
>>Thanks
>>DS

Thanks Karl.
It worked perfectly!
DS

Reply to this Message