How should I accomplish this?

[_Bigred]

I want to have a table that contains the following fields:


StartDate
EndDate
Teams


Ultimately I would like the table to base a report on. I would like to be
able to generate a breakdown like such:

StartDate EndDate Teams
8/21 8/27 3&4
8/28 9/3 1&2
9/4 9/10 3&4
9/11 9/17 1&2

note: the above dates are sunday-saturday and would run indefinitely (no end
date - would continue year after year).
The Teams would alternate Team 3&4 on one week, then the next week would be
Teams 1&2 (this would also remain the same with no end "year after year").

I really don't know the best method to accomplish, how should I setup my
table/tables and then how would I accomplish the above scenario?

TIA,
_Bigred

 

[Duane Hookom]

I would just create this in Excel and probably place the teams in separate
columns. If you need this in Access, import it.