"=?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
|