Welcome to SPN

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

Sign Up Now!

condition in some fields

Discussion in 'Information Technology' started by maha, Jul 28, 2006.

  1. maha

    maha
    Expand Collapse
    Guest

    hi all,
    i have new project to do with MS Access and i was new in this application so
    i have some problems plz if any one know it plz answer me:)
    my application hold information about student and subject so i create
    form,maco
    but i need to caluclate student absence date then for each day they absence
    i must decrease 10$ from thier account in university "both absence date and
    account are fields in student table"
    so plz can u tell me how to hold this condition in student tables???
    i have another question about how to combine all forms and reports toghther
    to make one complete application????
     
  2. Loading...

    Similar Threads Forum Date
    I am feeling very very down right now ... What can I do to improve my condition. A hopeless feeling. Sikh Youth Oct 15, 2013
    India Condition Of Shaheed Udham Singh's Family... Breaking News Aug 9, 2011
    Inspirational Unconditional love for the Guru Videos Sep 4, 2010
    General Unconditional Love Hard Talk Jun 28, 2008
    Pure and Unconditional Love for God Gurmat Vichaar Feb 18, 2008

  3. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    You should have a second table separate from student to track absence and set
    a one-to-many relationship.

    >>i must decrease 10$ from thier account in university

    Do you have a separate table for transactions to their account? The
    transaction table would have data like this –
    StudentID TransDate Amount Reason
    A453D5 2/1/06 250.00 Deposit to account
    A453D5 2/15/06 -10.00 Deduct $10 from account for absence on
    2/5/06
    A453D5 3/1/06 -25.00 Deduct $25 from account for book
    purchase
    Then use a totals query to show balance.


    >>i have another question about how to combine all forms and reports toghther to make one complete application????

    Search on Switchboard.


    "maha" wrote:

    > hi all,
    > i have new project to do with MS Access and i was new in this application so
    > i have some problems plz if any one know it plz answer me:)
    > my application hold information about student and subject so i create
    > form,maco
    > but i need to caluclate student absence date then for each day they absence
    > i must decrease 10$ from thier account in university "both absence date and
    > account are fields in student table"
    > so plz can u tell me how to hold this condition in student tables???
    > i have another question about how to combine all forms and reports toghther
    > to make one complete application????
     
  4. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest


    >>"both absence date and account are fields in student table"

    You should have a second table separate from student to track absence and
    set a one-to-mant relationship.

    >>i must decrease 10$ from thier account in university

    Do you have a separate table for transactions to their account?

    >>i have another question about how to combine all forms and reports toghther

    to make one complete application????
    Search on Switchboard.

    "maha" wrote:

    > hi all,
    > i have new project to do with MS Access and i was new in this application so
    > i have some problems plz if any one know it plz answer me:)
    > my application hold information about student and subject so i create
    > form,maco
    > but i need to caluclate student absence date then for each day they absence
    > i must decrease 10$ from thier account in university "both absence date and
    > account are fields in student table"
    > so plz can u tell me how to hold this condition in student tables???
    > i have another question about how to combine all forms and reports toghther
    > to make one complete application????
     
  5. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Fri, 7 Jul 2006 12:50:02 -0700, maha
    <maha@discussions.microsoft.com> wrote:

    >hi all,
    >i have new project to do with MS Access and i was new in this application so
    >i have some problems plz if any one know it plz answer me:)
    >my application hold information about student and subject so i create
    >form,maco
    >but i need to caluclate student absence date then for each day they absence
    >i must decrease 10$ from thier account in university "both absence date and
    >account are fields in student table"


    >so plz can u tell me how to hold this condition in student tables???


    You cannot.

    Instead, you need TWO tables. The student table would contain only
    static biographical information about the student - nothing about
    attendance or absences. That information would be stored in a second
    table, related one-to-many to the student table by a StudentID field.
    If a student is absent six times, there would be six records for that
    student in the absences table.

    >i have another question about how to combine all forms and reports toghther
    >to make one complete application????


    You usually wouldn't do this. An Access Database is a container for
    multiple forms, reports, queries, tables, and other objects; usually
    you would have a "switchboard" or "menu" form which can be used to
    select which other forms and reports the user wants to open.

    John W. Vinson[MVP]
     

Share This Page