Add a new column in query that displays "Sleep In" if column A is greater than 9.55pm

[Elmobram22]

Add a new column in query that displays "Sleep In" if column A is greater than 9.55pm

Hi all,

I have a query I am building and I would like an extra column that shows "Sleep In" if the time out column is after 9.55pm and before 12am and by blank if before 9.55pm. I want to show all values but only show "sleep in" in the ones it needs to. I have attached the database to show what I mean.

Cheers,

Paul

 

[plog]

Re: Add a new column in query that displays "Sleep In" if column A is greater than 9.

You can use part of the code I wrote you from this post:

http://www.access-programmers.co.uk/forums/showthread.php?t=254128


Look at what I did with the TinMinute variable.

 

[Elmobram22]

Re: Add a new column in query that displays "Sleep In" if column A is greater than 9.

Hi,

Yeah I tried to do something like that but it just stopped the whole thing from working. I'm not very well up on modules. I'm a macro kind of guy!

Cheers

Paul