How can I...

[top1hat19]

I am setting up a database with a list of funds and a quarterly score for each one (1-100). Every quarter, I plan on saving the old quarter as a new table (ex. 2011 Q1 table), and importing the new quarter into the Current Quarter Table.



What I want is for the Current Quarter to check the score of the previous quarter, and if they are both under 50, add something to one of the current table's feilds. Any idea how to do this?

[ajetrumpet]

this doesn't make much sense. you'd be much better off using one table and using lookup functions in a form to show what you want to show.

[top1hat19]

What doesnt make sense? I want to save a record of every quarter, and I want each quarter to automatically know what the last quarter's scores were.

[ajetrumpet]

it doesn't make sense to make one table per quarter.

[top1hat19]

Is there a better way to do it? Im open to suggestions

[ajetrumpet]

yes...from what it sounds like, use one table. one column that specifies that quarter and one other that specifies the year