Search results

Hi everyone, I wonder if someone could help me. I am trying to write a query for a hospital database which counts the number of patients who received various treatments throughout their stay in intensive care. I think I will have trouble explaining textually what I would like to achieve so I...

Hi, I am trying to query on a table, predominantly made up of check boxes, so that I can get a summary which essentially shows the number of 'checks' in each field within a given date range. I have attached a Word file, which should explain exactly what I would like to achieve. If anyone can...

Dear all, I have been provided with the following code to automatically enter the date in a field (TreatmentDate), based on two dates (StartDate and EndDate) entered in another table. This is an example of how the result should look; Table 1: PatientID: 123456 StartDate: 01/01/2005 EndDate...

Hello, I have two tables which contain the following fields (simplified); Table 1: ID Startdate Enddate Table 2: ID Unitdate Treatment The tables are related (one-to-many) through the ID field. In operation, the user first enters the Startdate and an Enddate for a patients' hospital stay in...

Hi, I have a database consisting of two forms (MAIN and CONSULTANTS). One of these forms (CONSULTANTS) contains the fields, which are the source for a lookup list of names on the first form (MAIN). The fields contained in the CONSULTANTS form/table are as follows; TITLE (Mr, Mrs, Dr. etc)...

Hi, I have a form, used in a medical database, which contains the lookup field DOCTOR, which updates depending on the contents of a table called DOCTORINFO. Next to this field I have a command button which, when pressed, opens the DOCTORINFO form, allowing the user to enter the name details...

Hi, I have a command button on page 1 of a form, which, when pressed, I would like to move to the first field on page 2 of the form. I have achieved this to some extent using a simple macro. However, this is what I would really like to happen; (1) After tabbing out of the last field on the...

Hi, I have a database which contains, amonst others, two fields; (1) Treatment_provided - a YES/NO response being required. (2) Number_of_days_of_treatment - a number field When first opening the data entry form I would like a default value of "NO" in the Treatment_provided field, and the...

Hi there! I wonder if someone can help me please? I have an Access 2000 database used to record the daily treatments received by patients in our Intensive Care Unit. The database consists of 2 tables; Table 1 has these fields; [First Name], [Surname], [Hospital Number], [ICU Admission...