Medical Assessment with more than 255 fields

Sorry...and more question from my last question, if the yes/no fields
actually appear as records within that table, how would this appear on the
form for the clinicians to check off? Will they be able to see all their
"options" if I list them in table?

"Jaz" wrote:

ok please forgive me if this sounds like an stupid question, I am a newbie
and really appreciate your patience.....

I think I understuand your structure, however when it comes to the
SectionCheckboxFieldName, so are you saying for each yes/no field that I
have, it will not actually be a field, it will be a record within the
TblSectionCheckList table?

Do you know of any sample database out there with a similar set up?

"Mark" wrote:

If you follow the table design I suggested, at most you will have ten fields
in your query!!

Steve



"Jaz" wrote in message
news
Thanks Michael for your help. To answer your question, the majority is
only
yes/no check boxes. They want it that way because of risk management
purposes. All the necessary assessment indicators that they need to
address/rate are in front of them, so it is either yes/no. There may be
the
odd text box here an there for annotation purposes. The clinicians will
be
doing this in real time, so what they are wanting is ONE FORM, that they
can
just scroll down and simply check off all the pertinant information using
yes/no check.

There are about 10 different sections (i.e. presenting problems,
Diagnosis;
Orientation to time & place, social supports) and each of these sections
has
at least 15 options (in the form of yes/no checkboxes). I can't do a
combo-box because there can be multiple answers under each section.

How can I create a report from a query when all you are allowed is 255
fields in the query? I have counted and all together there are 475
check-boxes and fields in this form. I will also have to pull up some
form
so they can search previous entries for the patient.




"Michael Gramelspacher" wrote:

On Fri, 6 Jun 2008 14:29:03 -0700, Klatuu

wrote:

You are correct. I misread your closing statement.
What you propose would be the way I would do it.

Well, I don't know. I see these tables:

Patients
Assessments
Sections
Checklists
Questions

And these relationships:

Patient Assessments
AssessmentSections
SectionChecklists
ChecklistQuestions
PatientAssessmentResponses

The OP seems to want the responses to always be Yes or No.

It seems to be a bit more than trival. Well, to me at least. We need
more
information. Is a section the same as a checklist? Can a section have
more
than 1 checklist? Can responses ever be anything other than yes/no?

Here is a diagram I did, not that it is necessarily correct. It seems that
Section and Checklist are really the same thing.
http://www.psci.net/gramelsp/temp/Pa...ssessments.jpg

Take a look at this. It is indeed crude, but I think it is close to what you
need, of course, based on my understing of the problem.

http://www.psci.net/gramelsp/temp/Crude_Example.zip

It was a little tricky for me.





On Sat, 7 Jun 2008 09:55:00 -0700, Jaz wrote:

Thanks Michael for your help. To answer your question, the majority is only
yes/no check boxes. They want it that way because of risk management
purposes. All the necessary assessment indicators that they need to
address/rate are in front of them, so it is either yes/no. There may be the
odd text box here an there for annotation purposes. The clinicians will be
doing this in real time, so what they are wanting is ONE FORM, that they can
just scroll down and simply check off all the pertinant information using
yes/no check.

There are about 10 different sections (i.e. presenting problems, Diagnosis;
Orientation to time & place, social supports) and each of these sections has
at least 15 options (in the form of yes/no checkboxes). I can't do a
combo-box because there can be multiple answers under each section.

How can I create a report from a query when all you are allowed is 255
fields in the query? I have counted and all together there are 475
check-boxes and fields in this form. I will also have to pull up some form
so they can search previous entries for the patient.




"Michael Gramelspacher" wrote:

On Fri, 6 Jun 2008 14:29:03 -0700, Klatuu
wrote:

You are correct. I misread your closing statement.
What you propose would be the way I would do it.

Well, I don't know. I see these tables:

Patients
Assessments
Sections
Checklists
Questions

And these relationships:

Patient Assessments
AssessmentSections
SectionChecklists
ChecklistQuestions
PatientAssessmentResponses

The OP seems to want the responses to always be Yes or No.

It seems to be a bit more than trival. Well, to me at least. We need more
information. Is a section the same as a checklist? Can a section have more
than 1 checklist? Can responses ever be anything other than yes/no?

Take a look at "At Your Survey" found at
http://www.rogersaccesslibrary.com/O...p#Hookom,Duane. This demo
was originally created for a medical survey.
--
Duane Hookom
Microsoft Access MVP


"Jaz" wrote:

Sorry...and more question from my last question, if the yes/no fields
actually appear as records within that table, how would this appear on the
form for the clinicians to check off? Will they be able to see all their
"options" if I list them in table?

"Jaz" wrote:

ok please forgive me if this sounds like an stupid question, I am a newbie
and really appreciate your patience.....

I think I understuand your structure, however when it comes to the
SectionCheckboxFieldName, so are you saying for each yes/no field that I
have, it will not actually be a field, it will be a record within the
TblSectionCheckList table?

Do you know of any sample database out there with a similar set up?

"Mark" wrote:

If you follow the table design I suggested, at most you will have ten fields
in your query!!

Steve



"Jaz" wrote in message
news Thanks Michael for your help. To answer your question, the majority is
only
yes/no check boxes. They want it that way because of risk management
purposes. All the necessary assessment indicators that they need to
address/rate are in front of them, so it is either yes/no. There may be
the
odd text box here an there for annotation purposes. The clinicians will
be
doing this in real time, so what they are wanting is ONE FORM, that they
can
just scroll down and simply check off all the pertinant information using
yes/no check.

There are about 10 different sections (i.e. presenting problems,
Diagnosis;
Orientation to time & place, social supports) and each of these sections
has
at least 15 options (in the form of yes/no checkboxes). I can't do a
combo-box because there can be multiple answers under each section.

How can I create a report from a query when all you are allowed is 255
fields in the query? I have counted and all together there are 475
check-boxes and fields in this form. I will also have to pull up some
form
so they can search previous entries for the patient.




"Michael Gramelspacher" wrote:

On Fri, 6 Jun 2008 14:29:03 -0700, Klatuu

wrote:

You are correct. I misread your closing statement.
What you propose would be the way I would do it.

Well, I don't know. I see these tables:

Patients
Assessments
Sections
Checklists
Questions

And these relationships:

Patient Assessments
AssessmentSections
SectionChecklists
ChecklistQuestions
PatientAssessmentResponses

The OP seems to want the responses to always be Yes or No.

It seems to be a bit more than trival. Well, to me at least. We need
more
information. Is a section the same as a checklist? Can a section have
more
than 1 checklist? Can responses ever be anything other than yes/no?

Wow....thank yo so much for the sample Very kind of you. It does indeed
look tricky. I am going to examine it closer and see if I can figure out
your design. Thanks again so much.


"Michael Gramelspacher" wrote:

Here is a diagram I did, not that it is necessarily correct. It seems that
Section and Checklist are really the same thing.
http://www.psci.net/gramelsp/temp/Pa...ssessments.jpg

Take a look at this. It is indeed crude, but I think it is close to what you
need, of course, based on my understing of the problem.

http://www.psci.net/gramelsp/temp/Crude_Example.zip

It was a little tricky for me.





On Sat, 7 Jun 2008 09:55:00 -0700, Jaz wrote:

Thanks Michael for your help. To answer your question, the majority is only
yes/no check boxes. They want it that way because of risk management
purposes. All the necessary assessment indicators that they need to
address/rate are in front of them, so it is either yes/no. There may be the
odd text box here an there for annotation purposes. The clinicians will be
doing this in real time, so what they are wanting is ONE FORM, that they can
just scroll down and simply check off all the pertinant information using
yes/no check.

There are about 10 different sections (i.e. presenting problems, Diagnosis;
Orientation to time & place, social supports) and each of these sections has
at least 15 options (in the form of yes/no checkboxes). I can't do a
combo-box because there can be multiple answers under each section.

How can I create a report from a query when all you are allowed is 255
fields in the query? I have counted and all together there are 475
check-boxes and fields in this form. I will also have to pull up some form
so they can search previous entries for the patient.




"Michael Gramelspacher" wrote:

On Fri, 6 Jun 2008 14:29:03 -0700, Klatuu
wrote:

You are correct. I misread your closing statement.
What you propose would be the way I would do it.

Well, I don't know. I see these tables:

Patients
Assessments
Sections
Checklists
Questions

And these relationships:

Patient Assessments
AssessmentSections
SectionChecklists
ChecklistQuestions
PatientAssessmentResponses

The OP seems to want the responses to always be Yes or No.

It seems to be a bit more than trival. Well, to me at least. We need more
information. Is a section the same as a checklist? Can a section have more
than 1 checklist? Can responses ever be anything other than yes/no?

The form and the two subforms are straight forward, if you understand subforms.
If you select a section in the first subform, nothing will show in the second
subform initially. You need to click the Create List command button to fill it
with questions with default responses. I could have made a checkbox for YesNo
or an option group, but then there could never be anything but yes or no, which
is probably not the case. Of course, you could insert another column in the
table for a free-text response in addition to a YesNo response:

Question: Have you ever had an operation? if Yes, explain. Yes No
(explanation)

The tricky part was the query record source for the second subform. It had to
be updateable, and it had to show the sequence number of the question.



On Sun, 8 Jun 2008 00:39:01 -0700, Jaz wrote:

Wow....thank yo so much for the sample Very kind of you. It does indeed
look tricky. I am going to examine it closer and see if I can figure out
your design. Thanks again so much.


"Michael Gramelspacher" wrote:

Here is a diagram I did, not that it is necessarily correct. It seems that
Section and Checklist are really the same thing.
http://www.psci.net/gramelsp/temp/Pa...ssessments.jpg

Take a look at this. It is indeed crude, but I think it is close to what you
need, of course, based on my understing of the problem.

http://www.psci.net/gramelsp/temp/Crude_Example.zip

It was a little tricky for me.





On Sat, 7 Jun 2008 09:55:00 -0700, Jaz wrote:

Thanks Michael for your help. To answer your question, the majority is only
yes/no check boxes. They want it that way because of risk management
purposes. All the necessary assessment indicators that they need to
address/rate are in front of them, so it is either yes/no. There may be the
odd text box here an there for annotation purposes. The clinicians will be
doing this in real time, so what they are wanting is ONE FORM, that they can
just scroll down and simply check off all the pertinant information using
yes/no check.

There are about 10 different sections (i.e. presenting problems, Diagnosis;
Orientation to time & place, social supports) and each of these sections has
at least 15 options (in the form of yes/no checkboxes). I can't do a
combo-box because there can be multiple answers under each section.

How can I create a report from a query when all you are allowed is 255
fields in the query? I have counted and all together there are 475
check-boxes and fields in this form. I will also have to pull up some form
so they can search previous entries for the patient.




"Michael Gramelspacher" wrote:

On Fri, 6 Jun 2008 14:29:03 -0700, Klatuu
wrote:

You are correct. I misread your closing statement.
What you propose would be the way I would do it.

Well, I don't know. I see these tables:

Patients
Assessments
Sections
Checklists
Questions

And these relationships:

Patient Assessments
AssessmentSections
SectionChecklists
ChecklistQuestions
PatientAssessmentResponses

The OP seems to want the responses to always be Yes or No.

It seems to be a bit more than trival. Well, to me at least. We need more
information. Is a section the same as a checklist? Can a section have more
than 1 checklist? Can responses ever be anything other than yes/no?

I'll answer both your questions here ....

Before entering any patient assessment data in your database, you would need
to fill TblSection and TblSectionChecklist first. TblSection would look
like:

1 Presenting Problems
2 Diagnosis
3 Orientation To Time And Place
4 Social Supports
etc ....

In TblSectionCheckList, SectionCheckboxFieldName are your options. You would
have a record in this table for each option in each section.
SectionCheckboxFieldName are your option questions NOT Yes/No answers.
TblSectionCheckList would look like:

1 1 Option Question1 For Presenting Problems
2 1 Option Question2 For Presenting Problems
.....
15 1 Option Question15 For Presenting Problems
16 2 Option Question1 For Diagnosis
17 2 Option Question2 For Diagnosis
.....
30 2 Option Question15 For Diagnosis
31 2 Option Question1 For Orientation To Time And Place
32 2 Option Question2 For Orientation To Time And Place
.....
45 2 Option Question15 For Orientation To Time And Place
etc ....

For each patient assessment, the answers (Yes or No) to the option questions
would be recorded in TblAssessment. I forgot to include in my previous
response one field in my proposed tables for TblAssessment. You need to add
a field named YesNoResponse to TblAssessment. YesNoResponse would be where
you record Yes or No for each option question.

Steve




"Jaz" wrote in message
...
Sorry...and more question from my last question, if the yes/no fields
actually appear as records within that table, how would this appear on the
form for the clinicians to check off? Will they be able to see all their
"options" if I list them in table?

"Jaz" wrote:

ok please forgive me if this sounds like an stupid question, I am a
newbie
and really appreciate your patience.....

I think I understuand your structure, however when it comes to the
SectionCheckboxFieldName, so are you saying for each yes/no field that I
have, it will not actually be a field, it will be a record within the
TblSectionCheckList table?

Do you know of any sample database out there with a similar set up?

"Mark" wrote:

If you follow the table design I suggested, at most you will have ten
fields
in your query!!

Steve



"Jaz" wrote in message
news Thanks Michael for your help. To answer your question, the majority
is
only
yes/no check boxes. They want it that way because of risk management
purposes. All the necessary assessment indicators that they need to
address/rate are in front of them, so it is either yes/no. There may
be
the
odd text box here an there for annotation purposes. The clinicians
will
be
doing this in real time, so what they are wanting is ONE FORM, that
they
can
just scroll down and simply check off all the pertinant information
using
yes/no check.

There are about 10 different sections (i.e. presenting problems,
Diagnosis;
Orientation to time & place, social supports) and each of these
sections
has
at least 15 options (in the form of yes/no checkboxes). I can't do a
combo-box because there can be multiple answers under each section.

How can I create a report from a query when all you are allowed is
255
fields in the query? I have counted and all together there are 475
check-boxes and fields in this form. I will also have to pull up
some
form
so they can search previous entries for the patient.




"Michael Gramelspacher" wrote:

On Fri, 6 Jun 2008 14:29:03 -0700, Klatuu

wrote:

You are correct. I misread your closing statement.
What you propose would be the way I would do it.

Well, I don't know. I see these tables:

Patients
Assessments
Sections
Checklists
Questions

And these relationships:

Patient Assessments
AssessmentSections
SectionChecklists
ChecklistQuestions
PatientAssessmentResponses

The OP seems to want the responses to always be Yes or No.

It seems to be a bit more than trival. Well, to me at least. We
need
more
information. Is a section the same as a checklist? Can a section
have
more
than 1 checklist? Can responses ever be anything other than yes/no?