Search results

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

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

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

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

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

I have a database in access 97. I have one field in each record which I would like to place in a report. I would like to place each field on a page sequentially instead of having each field on a separate line. The setup of the information is as follows: Record 1-field (answer) Record 2-field...

I have a form that asks question which are answered by my patients. If a specific answer for example is "no" I would like to have the command button that brings up the next question skip to a certain question number instead of the next question. I have been able to skip questions using...

I have a program in Access 97 that I have been working on to interview my patients before I see them. They are asked multiple questions. The answers to these questions are in one table with one answer per record. I would like to be able to print these in a report in sequential order instead...