Recent content by Ben McCall

I understand the importance of separate fields but I have a specific need to combine several fields to meet the requirements of a merge fax program. I can combine fields in a copy and keep the original "pure". Thanks! Ben McCall

I am not interested in a form or a report. All I want to do is merge three fields into one field in the table and then delete the three original fields. Thanks! Ben McCall

Is there any way to merge the contents of three columns in to one column. Title First Name Last Name Mr. & Mrs. Ben McCall to give: Name Mr. & Mrs. Ben McCall Ben McCall

This is a medical history questionnaire. So ther are no correct or incorrect answers. Ben

I am working on a questionnaire in Access 97. I have had no difficulty setting up questions with multiple choice answers where only one answer is wanted or fill the blank questions where the "responder" types in an answer. I have been trying to set up a question were more than one answer may be...

The form is set up so that only one question is on a page. Therefore the answer to each question is a seperate record in "patientanswers" identified by the field "patient_id". If the responder is "patient_id" 5 and clicks on the previous field button on the main form, the subform will show the...

I have a database in access 97. I have a questionnaire form whose table is “question” which has three fields – “question_id”, “question_no”, and “question”. One subform has a table “answers” which has four fields – “answer_id”, “answer_no” , “question_no and “answer”. The answers are multiple...

Thanks! That solved the problem. Ben McCall

I guess that i did not explain it accurately. Both the form and the subform are open. I then click on a "previous button" which has the code: "Dim pre As Integer pre = 1 DoCmd.GoToRecord , , acPrevious" which sends me to the "if" code above. Ben McCall

I have a database in access 97. I have a main form with two subforms. I want to use a global variable "pre" in the main form and one subform. My understanding was that I could declare it in the main declarations of the main form as follows: Option Compare Database Option Explicit Public pre...

Thanks! That solved my problem. Ben McCall

That still gives me multiple stings - as many as there are records. Ben McCall

The last code above still gives me four strings instead of the one that I would like to have. Ben McCall

I want th report to show this: Record1[formatted answer] & Record1[answer] & “. “ & Record2[formatted answer] & Record2[answer] & “. “ & Record3[formatted answer] & Record3[answer] & “. “& Record4[formatted answer] & Record4[answer] & “. “ I get this but I get four copies of it. I would like...

I have a database in access 97. I have one table – “report” which contains two fields – “formatted answer” and “answer” in each record. I want to have a report that concatenates these fields sequentially on a line: [formatted answer] & “ “ & [answer] for each record with a space between each...