Tags: access, calendar, classroom, database, microsoft, monthly, mysql, oracle, separate, showingtheir, sql, students, track

trying to use access to keep track of students in a classroom

On Database » Microsoft Access

3,760 words with 5 Comments; publish: Thu, 05 Jun 2008 11:10:00 GMT; (25062.50, « »)

using access to keep track of my students. I have a monthly calendar showing

their hours each day. Now I want to separate my morning students from my

afternoon students...how do I used the filter/sort mode to accomplish this?

All Comments

Leave a comment...

  • 5 Comments
    • Would class times less than noon be morning students and class times greater

      than or equal to noon work for you?

      PC Datasheet

      Your Resource For Help With Access, Excel And Word Applications

      Over 1150 users have come to me from the newsgroups requesting help

      resource.ms-access.questionfor.info.pcdatasheet.com

      "Vergeront" <Vergeront.ms-access.questionfor.info.discussions.microsoft.com> wrote in message

      news:D451836D-FDC1-4184-B85A-3648218B6D95.ms-access.questionfor.info.microsoft.com...

      > using access to keep track of my students. I have a monthly calendar

      > showing

      > their hours each day. Now I want to separate my morning students from my

      > afternoon students...how do I used the filter/sort mode to accomplish

      > this?

      #1; Thu, 05 Jun 2008 11:11:00 GMT
    • Vergeront,

      Try this:

      Add a field to your table of students and name it, maybe, txtAmPm; data

      type, text.. Add an 'Option Group' to the form where students are entered.

      Make the first option, AM and the second option PM. You can only select one

      option with this method. If a student is both AM and PM, that's a different

      story-I digress.

      The first option will put a "1" in the table field, the second option will

      put a "2" in the table field. If you need a student with AM and PM, make a

      third option as All Day. Third option will put a "3" in the table field.

      Now you can sort/filter by the 'txtAmPm' field.

      Jim Ory

      "Vergeront" wrote:

      > using access to keep track of my students. I have a monthly calendar showing

      > their hours each day. Now I want to separate my morning students from my

      > afternoon students...how do I used the filter/sort mode to accomplish this?

      #2; Thu, 05 Jun 2008 11:12:00 GMT
    • thank you so much to your time and experience

      Vergeront

      "Jim Ory" wrote:

      [vbcol=seagreen]

      > Vergeront,

      > Try this:

      > Add a field to your table of students and name it, maybe, txtAmPm; data

      > type, text.. Add an 'Option Group' to the form where students are entered.

      > Make the first option, AM and the second option PM. You can only select one

      > option with this method. If a student is both AM and PM, that's a different

      > story-I digress.

      > The first option will put a "1" in the table field, the second option will

      > put a "2" in the table field. If you need a student with AM and PM, make a

      > third option as All Day. Third option will put a "3" in the table field.

      > Now you can sort/filter by the 'txtAmPm' field.

      > --

      > Jim Ory

      >

      > "Vergeront" wrote:

      #3; Thu, 05 Jun 2008 11:13:00 GMT
    • You're welcome.

      Jim Ory

      "Vergeront" wrote:

      [vbcol=seagreen]

      > thank you so much to your time and experience

      > Vergeront

      > "Jim Ory" wrote:

      #4; Thu, 05 Jun 2008 11:14:00 GMT
    • "PCD" <notmy.ms-access.questionfor.info.email.com> schreef in bericht =

      news:44mTf.14925$S25.10793.ms-access.questionfor.info.newsread1.news.atl.eart hlink.net...

      --=20

      > PC Datasheet

      > Your Resource For Help With Access, Excel And Word =

      Applications 'Resource ?=20

      > Over 1150 users have come to me from the newsgroups requesting =

      help '1150 users ?

      > resource.ms-access.questionfor.info.pcdatasheet.com

      >=20

      >=20

      --=20

      I did not overlook you here Steve...

      Oh well , never mind just read here:

      http://home.tiscali.nl/arracom/whoissteve.html=20

      Arno R

      #5; Thu, 05 Jun 2008 11:15:00 GMT