No, not at all Michael, i really do thank you for your input, i'm always very grateful for anybody who puts time into forums to try and help me out.

i'm...

Perfect Scott, that worked a treat, thanks !

Michael, your point about posting code has been duly noted, thanks for input.

sure, if i have 2 rows of data where row 1 contains data for May, Aug, Oct and row 2 has data for Jun, Jul and Oct I'm getting the...

Thanks Piers, looks like there some answers (and then some !) in there.

yep, that was the way to do it, in the SQL, makes sense now, for info the code i actually used was...

CASE WHEN DATEDIFF(SECOND, Attendance.DateTimeArrived, Attendance.DateTimeLeft) / 3600 = 0...

ok, how would i code it in the sql ??