A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How should I accomplish this?



 
 
Thread Tools Display Modes
  #1  
Old June 13th, 2006, 07:19 AM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default 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  
Old June 13th, 2006, 02:20 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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 10:19 AM
How can I accomplish this task? vrk1 General Discussion 2 November 12th, 2005 09: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


All times are GMT +1. The time now is 01:18 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.