On Tue, 30 Mar 2010 20:41:02 -0700, forest8
wrote:

Currently it's one field per issue.


So... when you add a new issue you need to redesign your table, change all
your queries, restructure all your forms, all your reports?

Sorry, but that design is *just plain wrong*, and is the source of your
difficulties with indexing and with form design. You're using a relational
database - use it relationally! Tables should be tall and thin, not wide and
flat; data should be stored in fields, not in fieldnames.

--

John W. Vinson [MVP]