I thought I had it figured out. but i definitely don't. Yes, all answers are
unique to the certain day and certain year. But the way it's set up, all
Q1's, Q2's are the same for all days and all years! Tha'ts not good. So maybe
I"m not understanding your syntax of how to keep them unique in the same
table.

Days(*YearNum, *DayNum, etc)

Will the * keep them unique? I need help!

THanks again.
"Tim Ferguson" wrote:

"=?Utf-8?B?TWltaQ==?=" wrote in
:

Now I need to figure out where to
go from here w/out completely starting over.

I am not sure that this is not the best place to start... :-)

Taking things from the top, I see that you have entities called

Years
Days
IDs
Questions
Answers

but I am not clear exactly how they all interact. Some things are
(probably) easy -- each Day belongs to exactly one Year; there is at most
one Answer for a given Question on a given Day by a particular ID; and so
on. My guess is that you are looking at tables something like this

Days(*YearNum, *DayNum, etc) to track days when surveys were taken

Questions(*QuestNum, TextOfQuestion, CorrectAnswer, AnswerType) which is
fairly obvious, except that if you make CorrectAnswer a text field,
then you can use it to store a numeric answer and set AnswerType to
a code that specifies "number", if you see what I mean. I would also
have urged you to keep all questions to a consistent answer type, but
you can't have everything!

Subjects(*SubjectID, FName, LName, Agegroup, Gender, etc)

Responses(*YearNum, *DayNum, *QuestNum, *SubjectID, GivenAnswer) This is
the table that holds one record for each question from each subject on
each day. You can group by year, or by day; do totals for each Subject,
and by suitable joins you can analyse by gender or agegroup etc etc.

One short cut would be to look at the ready-made At Your Survey database
from our very own Duane Hookom: check out
http://www.rogersaccesslibrary.com/OtherLibraries.asp

Even if it does not fit your needs exactly, you can see how to build a
similar application that does.

Hope that helps


Tim F