Thanks Tim. I definitely needed some help. Now I need to figure out where to
go from here w/out completely starting over. I'm new at this, so really
appreciate your advice. I should've planned better! 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