Search results

I have a query called 'Patients Extended' containing fields 'ID' (primary key from table 'Patients') and 'Client Code', also from the table 'Patients'). Is there a way I can use a SELECT statement in the row source for field 'Client Code' in the table 'Reviews' to get it to update with the...

I have a query called 'Patients' containing fields 'ID' (primary key from table 'Patients') and 'Client Code', also from the table 'Patients'). Is there a way I can use a SELECT statement in the row source for field 'Client Code' in the table 'Reviews' to get it to update with the client code...

The Client Code is stored in the Patients table. Is there a way I can also store this information in the Treatment table when it is entered into the Patients table via the Patients form? Unfortunately, I can't pull the database apart as I didn't design it and the department is reliant upon it...

Hi, I have a patient database with data stored in two tables. One form is used for entering personal details (First Name, Last Name, DOB, Patient Code, Sex, Address, Phone Number ect) for a patient. This is stored in the table called 'Patients'. Another form used for entering treatment data...

Thanks Doc-Man and others. I took the steps suggested previously and redesigned that particular form on a query so now have the average calculating as it should. Next problem I have encountered is with this function below on a different form...

Thanks for your reply. Can you tell me how to do that? I have tried this: =Sum([Field 1]+[Field 2]) But it isn't working. If 'Field 1' on my form contains the value '1' and 'Field 2' contains the value '3', the above expression produces the answer '13', rather than '4'. Help!

I can't as the rest of the form has to be based on the table. Is it possible then to calculate an average total in a form, based on values in other textboxes on that same form? This average total does not have to be stored. Thanks again.

Ok, but how would I get the value from that query back into the table so that it can be displayed on a form? Thanks.

Hi, I have a table with 4 different columns. Each column has a measurable indicator where the value can range from 1 to 10. In the last column, I would like the field to calculate the average score for the previous 3 columns in that row. Is there a way to do this? Thanks, David...

raskew - I'm getting the following error: 'Data type mismatch in query expression'. Any tips? Cheers again, David

raskew - Many thanks for the explanation, however, in my last post I already said that I had figured this part out. I am now stuck on how to create a chart showing the age distribution in the ranges I listed above. Can you help with this? Thank you. Edit: To be clear, here is the code...

Ok, slight update here. I have designed a query that returns the ages for all the birthdates in my table. I have created a textbox on my form, linking to the DOB field and used an expression that calculates the age for each record. This is working ok now. So, the first part of my query I...

Thank you both for the advice, but I am unsure how to implement it. As obvious as it is, I didn't realise that the ages column in the table would quickly become out of date. So, to break this down the first thing I should do is remove the 'Age' column from my table, 'Patients', and leave the...

Hi, I have a table containing patient data, including a column which has dates of birth for all patients, and another column containing the ages of all patients. I would like to produce a report containing a chart of all patients split into ages ranges as follows: <15, 15-19, 20-24, 25-29...

Anyone? If it can't be done the way I described, any other examples of how I could implement a scoring scale (1 - 10) in an Access form would be appreciated.

Hi, I am attempting to create a database that can score patients based on symptoms. Each assessment criteria is scaled from 1 to 10 (10 being most severe). There are 25 different assessment criteria that each have this scale. I would like to create a form whereby it is possible to enter a...

Hi, I have the a command button on a form which has the following code on click: DoCmd.TransferText acImportDelim, , "Patients", _ "T:\Practice Recovery Plans\data\import.csv", -1 However, what I would like to have is to be presented with a dialog box asking me to choose a csv file to...

Well, what can I say? It worked! Thank you. My next query involves reporting by period. I notice that there is also an option in your template to have it run off reports based on dates? Is there a way that I can run reports based on a period? For example, my reports are based on individual...

Many thanks for your response. I see the two forms you mention, and I don't mind using a list box instead of a combo box. When I import them into my database, how do I link the two list boxes to the reports in my database? For example, I have a group of reports called 'North Reports', which...

Is there an example in that database you were referring to? I don't see anything on the forms similar to what I am looking for (although the calendar template will come in handy later).