Search results

I've only just managed to fix a baffling error in one of my database reports after much :banghead:. I thought I would share the very simple solution for anyone else who may encounter similar. Basically, I had a form named 'ReportPage' that acted as a launchpad for a variety of reports. On...

I'm not sure that that title truly explains what I'm looking for. For each record in my database, there are observation periods which are recorded in the format dd/mm/yyyy hh:mm:ss, titles as follows 1st Obs Start 1st Obs End 2nd Obs Start 2nd Obs End 3rd Obs Start 3rd Obs End. I have been...

Hi all, To briefly explain my database; it is a bespoke referral management system within a hospital. Each record on the database contains patient demographic information, as well as information on their referral (i.e. date of referral, date of assessment, date of commencing treatment...

Hi all, I'll first of all explain the purpose of the query. I've built a database to record the admission details of patients admitted to hospital. Amongst other things, the database captures date/time of admission and date/time of discharge. The query I am building needs to show patients...