Search results

by the way vbainet - i noitice you are really active on this forum - do you get any remuneration? it is deserved!

No - I need it for 24 hours - sorry - should have said in my example Hourofday: IIf([Expr1] Between '00:00' And '00:59',"0", IIf([Expr1] Between '01:00' And '01:59',"1", IIf([Expr1] Between '02:00' And '02:59',"2", IIf([Expr1] Between '03:00' And '03:59',"3", IIf([Expr1] Between '04:00' And...

Hourofday: IIf([Expr1] Between '00:00' And '00:59',"0",IIf([Expr1] Between '01:00' And '01:59',"1","other")) for testing 2 hour groups

Funny that - I thought about doing it that way but that means an awfully long IIF statement doesn't it? - I would have to criteria for all 24hr Hourofday: IIf([Expr1] Between '00:00' And '00:59',"0","other") that is just for 1 hour

I have a table with ID Time (hh:mm) Hospital Is there a way I can set up a cross tab query that counts the number of episodes for each hospital between the hours of 00:00 - 00:59 01:00 - 01:59 ?? Cheers in advance

this works :-)

Hi please see attached

Just noticed this!!! lol

are you sure? all arrivetime entries fall between 18:01 and 07:59 hours? could you send my a copy of your version?

see where you getting at but A and B is start and end time here and my start time is 6 o clock at night, my end time is 8 in the morning

I had other criteria on my first query to look for records between 08:00 and 18:00. All I have done is change time to between 18:01 and 07:59 this should work on a 24 clock principle surely

This is strange If i try Between '18:01' And '07:59' it doesn't filter those occuring between those hours but it does if I choose Between '08:00' And '18:00'

ahaa. in the words of Goldfinger: "well played Mr Bond"

hi vbainet please see attached as requested bw tez

hmmm - still getting data type mismatch error if I usethat. I definitely have 'short time' chosen in the format option for the field in the table

this is a cross tab query though so If I remove the format from ORDER by and sort by date referred, all the records show. I want them group by month Date is my column head. I cannot add column headings in the properties box either because the date could have any start or end date

I have a report whose query is PARAMETERS [Forms]![frmReport]![startdate] DateTime, [Forms]![frmReport]![enddate] DateTime; TRANSFORM Nz(Count(qryEpisode.EpisodeID),0) AS CountOfID SELECT Format([Date_Referred],"yyyy/mmm") AS [Date] FROM qryEpisode WHERE (((qryEpisode.Date_Referred) Between...

Hi there I have a field which uses ShortTime format and have tried Not Between #23:00# And #07:00# but I get a data type mismatch error?

I have a two fields in a hospital admissions query that has been sent to me. I am trying write query to find which of those were out of hours (between 2000 hrs and 0800hrs) and which were in working hours (0800hrs and Date dd/mm/yyyy Time hh:mm:ss I want to find out I was wondering how I...

Many thanks for your support vbainet (again!)