Results 1 to 10 of 10
  1. #1
    Join Date
    Jun 2013
    Posts
    6

    Find monthly due fee

    Regards,
    I have a database with table student information where all students are recorded, i have another table with monthly transaction of fee. I need how to get report that which student paid fee and which not, this i want to check on just giving the month name ..

  2. #2
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    Please publish sample data
    (i.e. CREATE TABLE statements for "student information" and "monthly transaction of fee", and INSERT statements to populate the tables.).
    And expected result/output from the sample data.

  3. #3
    Join Date
    Jun 2013
    Posts
    6
    Thank you very much for your instant reply, sending you shortly a format

  4. #4
    Join Date
    Jun 2013
    Posts
    6
    Quote Originally Posted by tonkuma View Post
    Please publish sample data
    (i.e. CREATE TABLE statements for "student information" and "monthly transaction of fee", and INSERT statements to populate the tables.).
    And expected result/output from the sample data.
    Regards,

    Sample is attached with 2 table, in student information table on student informaation will be posted through form and in transaction through form monthly fee will be posted.

    Now i need a report or query to find which student is paid or not paid e.g. i want to write in a search box or form only month and want query to return unpaid student for that month.
    Attached Files Attached Files

  5. #5
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    I couldn't see your atached file.
    I unzipped the file, then I got one file("see") wihout extension.
    I tried to see the file("see") by Notepad and Internet Explorer. Both didn't show me meaningful information.

    Could you supply the information by text file?

  6. #6
    Join Date
    Jun 2013
    Posts
    6
    Sending you

  7. #7
    Join Date
    Jun 2013
    Posts
    6
    Quote Originally Posted by tonkuma View Post
    I couldn't see your atached file.
    I unzipped the file, then I got one file("see") wihout extension.
    I tried to see the file("see") by Notepad and Internet Explorer. Both didn't show me meaningful information.

    Could you supply the information by text file?


    Text format has been send, please be informed that the GR in transaction is a look-up in Gr with student information.
    Attached Files Attached Files

  8. #8
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    Quote Originally Posted by tonkuma View Post
    Please publish sample data
    (i.e. CREATE TABLE statements for "student information" and "monthly transaction of fee", and INSERT statements to populate the tables.).
    And expected result/output from the sample data.
    Would you mind to fill in data and/or to modify the following statements to make them complete and execuable?
    And, I want to know your expected result/output from the sample data.
    Code:
    CREATE TABLE student
    ( gr           /* what datatype? */ NOT NULL
    , student_name /* VARCHAR(xx)?   */ NOT NULL
    )
    ;
    
    CREATE TABLE transaction
    ( fee_month   /* what datatype? */ NOT NULL
    , gr          /* what datatype? */ NOT NULL
    , paid_amount /* INTEGER?       */ NOT NULL
    )
    ;
    Code:
    INSERT INTO student
    VALUES
      ( ??? , 'Alice Burtok'  )
    , ( ??? , 'Bruce Chen'    )
    , ( ??? , 'Carol Darwin'  )
    , ( ??? , 'David Smith'   )
    , ( ??? , 'Eliza Neumann' )
    ...
    ;
    
    INSERT INTO transaction
    VALUES
      ( ??? , ??? , ??? )
    , ( ??? , ??? , ??? )
    , ( ??? , ??? , ??? )
    , ( ??? , ??? , ??? )
    , ( ??? , ??? , ??? )
    , ( ??? , ??? , ??? )
    , ( ??? , ??? , ??? )
    , ( ??? , ??? , ??? )
    , ( ??? , ??? , ??? )
    , ( ??? , ??? , ??? )
    , ( ??? , ??? , ??? )
    ...
    ...
    ;

  9. #9
    Join Date
    Jun 2013
    Posts
    6
    Thank you very much indeed. I will send you shrotly as currently i am not getting what you asking from me as me very new to access, just what i need is to create 2 tables one contains student info like class, gr number, name, father name, monthly fee...

    then second table for transaction of fee like gr will be look up from table student info then paid month as month from look up list and amount paid is the paid amount..

    now just want a query to get records of paid students for the month asked in query and this would be done through a form just containing month query

  10. #10
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    ... I will send you shrotly as currently i am not getting what you asking from me as me very new to access, ...
    I hope you to understand what I asked to you, if you want some help from me.

    But, it's clear that you need not agree with my way.
    You can go your way with the persons who agree with you.

    Sorry,
    I might be a person who want different approach to describe(and to understand) the issues, than you.
    If so, I might not be able to help you so much.

Posting Permissions

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