Requested information from responses to my cry for Help

[Nip]

Thank you for your help!
I will try to explain this in a more easy to follow format
First I have 10 test participants who on each of 5 seperate dates will
grade a description.

PARTICIPANTID (auto number)
CaseParticipant (text because they are known only by an alpha numeric
code)
StartDate (each participant is different)

RANKDESCID (auto number)
RankDescription (text field as contains example: "Understanding goals"
or "salary paid" or "access to funds")

Each participant must answer each description on 8 different occasions
thus:

RANKDATEID (auto number)
RankDate (text field because contains things like "plan stage" and
"November 2005" so is a mixture of actual dates and times)

Each participant will use a variety of answers to the Rank Description
such:

RANKID (auto number)
Rank (text field because it will include numbers 1 through 5
representing Low to high but will also contain dollar amounts for salary
and words describing fund availability.

So at the end of the day I would like to do a report on each individual
participant ("alpha numeric designator") which will show each of the
rank descriptions and an answer for each of the dates:

CaseParticipant: rank description: date: answer

Plus I would like to be able to mix and match the information in other
words be able to see how many "1" Low ranks were given at planning stage
for goals and which participants rated the description low or high.

Hope this gives some better insight into what I am doing. The business
application is a tracking system for business planning exercise.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[rkc]

"Nip" <an*******@devdex.com> wrote in message
news:41**********************@news.newsgroups.ws.. .

Thank you for your help!
I will try to explain this in a more easy to follow format
First I have 10 test participants who on each of 5 seperate dates will
grade a description.

PARTICIPANTID (auto number)
CaseParticipant (text because they are known only by an alpha numeric
code)
StartDate (each participant is different)

RANKDESCID (auto number)
RankDescription (text field as contains example: "Understanding goals"
or "salary paid" or "access to funds")

Each participant must answer each description on 8 different occasions
thus:

RANKDATEID (auto number)
RankDate (text field because contains things like "plan stage" and
"November 2005" so is a mixture of actual dates and times)

Each participant will use a variety of answers to the Rank Description
such:

RANKID (auto number)
Rank (text field because it will include numbers 1 through 5
representing Low to high but will also contain dollar amounts for salary
and words describing fund availability.

So at the end of the day I would like to do a report on each individual
participant ("alpha numeric designator") which will show each of the
rank descriptions and an answer for each of the dates:

CaseParticipant: rank description: date: answer

Plus I would like to be able to mix and match the information in other
words be able to see how many "1" Low ranks were given at planning stage
for goals and which participants rated the description low or high.

Hope this gives some better insight into what I am doing. The business
application is a tracking system for business planning exercise.

It seems to me that your report pretty much describes the table needed
to store actual results of your application. All the other tables, if needed
at
all, simply serve as a means to control the values entered into that table.

< Results Table>
CaseParticipant -> allowed entry controlled by the participant table
rank description -> allowed entry controlled by the rankDescription table
date -> allowed entry controlled by the rankDated table
answer -> allowed entry controlled by an answers table
</ Results Table>

Other than the fact that the domain of the fields in your lookup tables
are not real well defined and your reports will end up with seemingly
mixed types of data...

I'm sorry, what was the question?