Merge date time fields

[tezread]

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 could 'merge' the two in a query so it read:

dd/mm/yyyy hh:mm:ss

?

Many thanks in advance

 

[vbaInet]

What are the two fields? What are their data types? What kind of values do they hold?