Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Attendance Sheet in Access

Discussion in 'Information Technology' started by dennishancy@eaton.com, Nov 9, 2005.

  1. dennishancy@eaton.com

    dennishancy@eaton.com
    Expand Collapse
    Guest

    I am envisioning a form in Access that allows you to enter attendance
    data. Here is an example of what I am hoping to achieve:

    11/1 | 11/2 | 11/3 |
    --------------------------------------------------------
    Randy | x | x | x |
    --------------------------------------------------------
    Amy | x | x | |
    --------------------------------------------------------
    Duane | | | x |
    --------------------------------------------------------


    I'd like the users to see that format when they enter attendence data.

    Any sugggestions as to how to set up the tables? or how to create a
    form that looks like this?

    I am thinking I want a separate table to hold the meeting dates. But
    somehow those meeting dates need to be column headings on the form.

    Thanks.


    Dennis Hancy
    Cleveland, OH
     
  2. Loading...

    Similar Threads Forum Date
    Funeral attendance Questions and Answers Jan 22, 2013
    1984 No Action Taken Against Policemen for Failure to File Chargesheet in Sajjan Case History of Sikhism Sep 2, 2011
    1984 Sajjan Chargesheet in Cold Storage History of Sikhism Mar 19, 2011
    India Ajmer blast case: RSS leader's name figures in charge sheet Breaking News Oct 24, 2010
    1984 Clubbing Charge-Sheet order against Sajjan on June 4 History of Sikhism Jun 3, 2010

  3. Lynn Trapp

    Lynn Trapp
    Expand Collapse
    Guest

    Dennis,
    What you are describing is the way you might do things in Excel but not in
    Access. What you want would make a data value (the date) to be the field
    name and it is never good to store data in a field name. If you set up a
    table with Attendee, AttendanceDate, and Attended fields you can then use a
    crosstab form to display the data in a report in the format you want, but it
    would not be possible to use a crosstab to do the data entry.

    --
    Lynn Trapp
    MS Access MVP
    www.ltcomputerdesigns.com
    Access Security: www.ltcomputerdesigns.com/Security.htm
    Jeff Conrad's Access Junkie List:
    http://home.bendbroadband.com/conradsystems/accessjunkie.html



    <dennishancy@eaton.com> wrote in message
    news:1131468578.417162.189230@g14g2000cwa.googlegroups.com...
    >I am envisioning a form in Access that allows you to enter attendance
    > data. Here is an example of what I am hoping to achieve:
    >
    > 11/1 | 11/2 | 11/3 |
    > --------------------------------------------------------
    > Randy | x | x | x |
    > --------------------------------------------------------
    > Amy | x | x | |
    > --------------------------------------------------------
    > Duane | | | x |
    > --------------------------------------------------------
    >
    >
    > I'd like the users to see that format when they enter attendence data.
    >
    > Any sugggestions as to how to set up the tables? or how to create a
    > form that looks like this?
    >
    > I am thinking I want a separate table to hold the meeting dates. But
    > somehow those meeting dates need to be column headings on the form.
    >
    > Thanks.
    >
    >
    > Dennis Hancy
    > Cleveland, OH
    >
     
  4. Fred Boer

    Fred Boer
    Expand Collapse
    Guest

    Dear Dennis:

    Lynn is an expert and can help you with Access, but have you seen these
    attendance templates that are available from Microsoft? It might serve as a
    basis to a solution that wouldn't involve Access:

    http://office.microsoft.com/en-us/templates/TC011887561033.aspx
    http://office.microsoft.com/en-us/templates/TC012291251033.aspx
    http://office.microsoft.com/en-us/templates/TC061893751033.aspx

    HTH
    Fred Boer




    <dennishancy@eaton.com> wrote in message
    news:1131468578.417162.189230@g14g2000cwa.googlegroups.com...
    >I am envisioning a form in Access that allows you to enter attendance
    > data. Here is an example of what I am hoping to achieve:
    >
    > 11/1 | 11/2 | 11/3 |
    > --------------------------------------------------------
    > Randy | x | x | x |
    > --------------------------------------------------------
    > Amy | x | x | |
    > --------------------------------------------------------
    > Duane | | | x |
    > --------------------------------------------------------
    >
    >
    > I'd like the users to see that format when they enter attendence data.
    >
    > Any sugggestions as to how to set up the tables? or how to create a
    > form that looks like this?
    >
    > I am thinking I want a separate table to hold the meeting dates. But
    > somehow those meeting dates need to be column headings on the form.
    >
    > Thanks.
    >
    >
    > Dennis Hancy
    > Cleveland, OH
    >
     
  5. Sprinks

    Sprinks
    Expand Collapse
    Guest

    Lynn,

    You've always been so clear in your assistance to me in the past, I hope
    you'll respond to my related post "Timesheet Application" in the Forms
    newsgroup.

    I am porting an Access application from Excel to simplify reporting and
    invoicing, but the current crosstabbed worksheet is very convenient to work
    from as it eliminates entering the date and project fields for each record.

    But although I can't use a crosstab for the data entry, perhaps I might
    construct a form for the data entry Bound to a dummy table, allow the user to
    confirm his entries at the end of the period, perform an Insert query to post
    the data to normalized tables, clear the dummy table, and create a new dummy
    record for the next period. A crosstab query could then present historical
    data for viewing.

    I'd appreciate your comments on this approach and/or any other suggestions
    on making this work.

    Sprinks

    "Lynn Trapp" wrote:

    > Dennis,
    > What you are describing is the way you might do things in Excel but not in
    > Access. What you want would make a data value (the date) to be the field
    > name and it is never good to store data in a field name. If you set up a
    > table with Attendee, AttendanceDate, and Attended fields you can then use a
    > crosstab form to display the data in a report in the format you want, but it
    > would not be possible to use a crosstab to do the data entry.
    >
    > --
    > Lynn Trapp
    > MS Access MVP
    > www.ltcomputerdesigns.com
    > Access Security: www.ltcomputerdesigns.com/Security.htm
    > Jeff Conrad's Access Junkie List:
    > http://home.bendbroadband.com/conradsystems/accessjunkie.html
    >
    >
    >
    > <dennishancy@eaton.com> wrote in message
    > news:1131468578.417162.189230@g14g2000cwa.googlegroups.com...
    > >I am envisioning a form in Access that allows you to enter attendance
    > > data. Here is an example of what I am hoping to achieve:
    > >
    > > 11/1 | 11/2 | 11/3 |
    > > --------------------------------------------------------
    > > Randy | x | x | x |
    > > --------------------------------------------------------
    > > Amy | x | x | |
    > > --------------------------------------------------------
    > > Duane | | | x |
    > > --------------------------------------------------------
    > >
    > >
    > > I'd like the users to see that format when they enter attendence data.
    > >
    > > Any sugggestions as to how to set up the tables? or how to create a
    > > form that looks like this?
    > >
    > > I am thinking I want a separate table to hold the meeting dates. But
    > > somehow those meeting dates need to be column headings on the form.
    > >
    > > Thanks.
    > >
    > >
    > > Dennis Hancy
    > > Cleveland, OH
    > >

    >
    >
    >
     

Share This Page