Recent content by usr33t

Hi, Similar, but not the same. The first query you helped me with counted all the instances of "Yes" in a date range for each type of treatment. Patients have an entry in this table for each day they spend on our intensive care unit. Each month we are required to report on the number of days...

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...

Thanks very much for that, That side of things works just fine now. What I would like to achieve next is explained in the attached file. If you could help me please, that would be great. Many thanks Russell

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...

Thanks Peter, Table 2 is set up as a sub-form within a main form based around Table 1. To call the procedure I have entered the following in the Default Value property for the TreatmentDate field in Table 2: =StartTreatment([VisitID]) Something that may help further in explaining the problem...

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...

Thanks again Scott, Definitely getting somewhere now I think. Just one more thing. On your original message, in which you listed the table structure, you have "FK" in brackets after PatientID in the tblVisit table and also after VisitID and TreatmentTypeID in the tblTreatments table. I...

Hello Scott, Thanks again for your help. I have examined your code and I think I can see how Access uses it - I have never played with Modules etc. to any great extent. Presumably one would now create a new Module and enter this code? Once entered, how would I get the code to "run" as it...

Hi Guys, Thanks for both your comments. Scott, I will give your elegant suggestion a go (i'm a bit a beginner to Acess in some respects) and let you know how I get on. Uncle Gizmo, thanks for your comments regarding my question. That's very kind. With best wishes to both of you. Russell

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...

Multiselect listbox Hello, I found JordanR's solution to the problem interesting and believe it may help me with a similar problem. I am very new to access, so if anyone knows exactly (step by step) how JordanR did this, or if anyone would be willing to point me in the direction of a sample...

Lookup list of names Ken, Cheers, that's brilliant! You may not have been 100% sure, but you were 100% right! Thanks a lot for that. Best regards Russell Usr33t

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)...

Thanks for that. I kind of understand what you mean but how exactly would I do this (i.e. what code etc would I use, and where would I put it)? Thanks again. Your help is very much appreciated. Cheers Russell (Usr33t)

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...