Thanks for all of your help. I am an Access newby. My question was for a database that was not normalized. I have since redesigned the database to normalize it and have been able to successfully pull the information I required. Thanks again for all of your help!
I have a series of fields (in a query, calculated off of table values) with essentially the same info for different years. I.E. DueOne has the due date for YearOne, DueTwo has the due date for YearTwo--there are seven of these for each entry (each entry needs to have info for seven years worth...