I understand YearNum and DayNum, but how would I have some questions about
Answer. Some of my Answers are text fields and others are an Option Box so
need 1-6. Can I define it to be text and Number, or I assume numbers are
allowed in Text boxes. But is this the best way?

Thanks again.

"Tim Ferguson" wrote:

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

So is it wrong to keep it the way it is on my YEAR table?

yes: almost certainly what would have been better would be one long table
structured something like

YearNum DayNum Answer
1999 009 Something
1999 010 Something else
2000 009 A new millenium

and so on. That way you could filter on year and days and group and sort as
well as you like. And Access will much _much_ faster and more efficiently
with a "long, narrow" table than a short fat one.


PS. I'm also having issues with the text field size. I originally used

... but this did not go back and change my existing fields

No: you will have to redesign every field in every table that you want
changed.

Hope that helps


Tim F