Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Jul 2005
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Info Sheet (Access 2000)

    How can I make an information sheet that will start with Sunday and end with Saturday and breakdown the list in days of the week?

    Example:
    Sunday
    List Events
    Monday
    List Events etc.

    Thanx in advance for your help~M

  2. #2
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Info Sheet (Access 2000)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29>
    Welcome to Woody's Lounge!

    The *best* way I can think of (if you just want to use those days, and not by date) would be to have two tables....shown below. Create your tables with the following criteria:
    tblDays
    -ID - Number field
    -Day - True name of day of week

    tblTasks
    -Day - You can use the lookup wizard to either link to tblDays by ID, or by Day (my example shows ID)
    -Task - Memo field

    Create a query that displays both tables, drag Day from the tblDays table, and Task from the tblTasks table onto the query grid.

    If you want to show all days of the week (including those with no "tasks", right click on the line between the two tables (the "link"), and choose 'Edit relationship'. Choose the option that says "Show all records from tblDays and only those records from tblTasks where the joined fields are equal."
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

  3. #3
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Info Sheet (Access 2000)

    I've created/attached a very simple example. Feel free to ask questions - this is the place to do it! <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

  4. #4
    New Lounger
    Join Date
    Jul 2005
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Info Sheet (Access 2000)

    Thanx, but the sheet is really an infomation sheet based on reservation and catering informatio.
    I need to list events by the day of the week.
    DAY OF WEEK Date
    # Name Group Event StartTime EndTime Location
    I'm just trying to get it to seperate and list?
    Thanx in advance for the help~M

  5. #5
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Info Sheet (Access 2000)

    Do you have an example of exactly how you'd like it to be made (in excel, or even word?) If so, can you attach it?
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Info Sheet (Access 2000)

    Access reports have sorting and grouping capabilities. If you group on a date field, you can specify whether you want to group by day, week or month.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •