Solved Query to set time basted on another field... (1 Viewer)

[Number11]

Hi, so i need to create a query that will look at a field within my table called DelWin and then put within the query 08:00 if AM or AD and if PM then 13:00

I have tried this but its not working


EARLIEST: IIf([DelWin]=AM,"08:00") Or IIf([DelWin]=PM,"13:00") Or IIf([DelWin]=AD,"08:00")

 

[Number11]

Ok got it working now using for a single


EARLIEST: IIf([DelWin]>"AM","08:00") how to get them all now working together?

 

[theDBguy]

How about?

EARLIEST: IIf([DelWin]="AM" Or [DelWin]="AD", #08:00#,IIf([DelWin]="PM",#13:00#,""))

 

[Gasman]

Try

EARLIEST: IIf([DelWin]='AM' OR DelWin = 'AD','08:00','13:00')

as any other tests your try might not be alphabetical?

HTH

 

[Number11]

How about?

EARLIEST: IIf([DelWin]="AM" Or [DelWin]="AD", #08:00#,IIf([DelWin]="PM",#13:00#,""))

Yes this is working but getting error when the DelWin has no data - so need to add something to cover if NULL then say 08:00?

 

[theDBguy]

Yes this is working but getting error when the DelWin has no data - so need to add something to cover if NULL then say 08:00?

Then how about?

EARLIEST: IIf(Nz([DelWin], "AM")="AM" Or [DelWin]="AD", #08:00#, IIf([DelWin]="PM", #13:00#, Null))

 

[Pat Hartman]

Or simplify:

EARLIEST: IIf(DelWin & "" ="PM", #13:00#, #08:00#))

 

[theDBguy]

Or simplify:

EARLIEST: IIf(DelWin & "" ="PM", #13:00#, #08:00#))

Nice! I didn't want to assume that AM, AD, and PM are the only possible entries in DelWin. I guess I should have asked. Cheers!