Search results

and I want all responses by one patient to show in one report (by responseid) I am so sorry for cutting off my messages..

I just compiled it with no problems. Deb

I just noticed, if I use qryMain2 for my listbox on main form calculation is done properly in my report but then in my list box i can see duplicates (actually then are not duplicates but just same patient responsed more then once)

Sorry, my attachment didn't go through. Here it is. Deb

Hi thank you for your reply. I did lot of changes and know it is working but the only problem is that if you select first name on the list (has two responses) and then click on the report it shows two reports for this person but second report keeps accumulating from first one (my query looks...

Hello, I am attaching my database as I gave up on my smartness. I have the following problem. There is online form for patients. Few times a year they are obligated to fill in the form so we can follow up on their progress. Each patient has unique medicalrecordid and every time they do the...

Hello, I have some problems with report I have to build. We have on line form and patient fill it in and submit it a few times a year. So each submission has unique response id. On my access form a have a list box with patient name, response id and medical record id. Medical record is unique...

Patient, with unque PatientID, can submit several surveys to our database (each survery has unique response id). How can I build one report per unique patientid (to see all reports he/she submitted in one report)

Hi George, Thank you for your reply and sorry for causing you frustration :) This is a bit more complicated then it sound. This is a questionnaire on line and asp is used to enable administrators to make questions on line and then make them available to patients. So one of my tables is...

Hello, On my main form I have a list box with our patient names and IDs. Some patients are entered a few times (but they have same patient record number). What I am trying to do is to have a list showing patient name only once and in report (which is accessible from this form) to show all...

It is a bit complex. My data is coming from the webform. The table name that holds answers is owsResponseAnswer. In this table I have only several fields: ResponseID, QuestionID, Date and Answers. There is a table called owsQuestion that has a field "QuestionDescription" and all these questions...

But how to do in the form as I would like to extract each question separately so I can change answers if needed, just for particular fields?

Hello, My data is coming to my access database from my webform but I would like to have an option for some fields to be altered/changed/added from my access form. So how can I refer to a field in my table? questionID is the field name but in my access form I would like to have several subfields...

Exactly like that. I jsut tried this: = DCount("[13] & [17]", "") to concatenate fields but it shows error message. Any suggestions? many thanks, Deb

Let say I have five fields and would like to count how many of them where answed related to particular patient (this total would go into mean calucation). How can I do this in report?

I have one more question. I want use count function but to count records from several fields =CDbl(Nz(Count([firstfield],[secondfield),0)). Where field is zero not to count it in. This function is working when I have only one field but when I add second I get an error message. Many thanks for...

Hello, I am trying to do a simple calculation in my report: = sum ([a] + [b] + [c] + [d] + [e]) but I keep getting an error message. This report is based on the crosstab query and these fields a,b,c... are text fields. I would greatly appreciate any suggestions. Many thanks, Deb

It is working when I entere criteria under responseid and parameteters. Many thanks, Deb

But how to associate that paramenter to choosen ID. I want ResponseID to have this parametar: [Forms]![Main]![ID]

Here it is: TRANSFORM Max(CStr(Trim([Answer]))) AS FullAnswer SELECT owsResponseAnswer.ResponseID FROM owsResponseAnswer INNER JOIN owsQuestion ON owsResponseAnswer.QuestionID = owsQuestion.QuestionID WHERE (((owsResponseAnswer.ResponseID)=[Forms]![Main]![ID])) GROUP BY...