If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How should I accomplish this?
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 |
#2
|
|||
|
|||
How should I accomplish this?
I would just create this in Excel and probably place the teams in separate
columns. If you need this in Access, import it. -- Duane Hookom MS Access MVP "_Bigred" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
multiple queries needed to accomplish task?? | Valerie | Running & Setting Up Queries | 5 | April 13th, 2006 12:02 AM |
Formula or Function to accomplish this? | elcapitan | Worksheet Functions | 6 | March 12th, 2006 09:19 AM |
How can I accomplish this task? | vrk1 | General Discussion | 2 | November 12th, 2005 08:42 PM |
how do you accomplish a trim ? | terryt | Visio | 3 | April 22nd, 2005 11:45 PM |
Form, query, or how to accomplish task??? | Meghan | General Discussion | 0 | June 21st, 2004 01:46 PM |