none
ACCESS PROBLEM WITH QUESTION RRS feed

  • Question

  • CREATE A REPORT  TO INCLUDE THE FOLLOWING 

    STUDENT NAME 

    TRAINER

    HOURS TRAINED

    PRICE PER HOUR

    TOTAL FEE 

    THE JUSTIFY TO LEFT

    DISPLAY ONLY RECORDS OF STUDENT WHO ARE TRAINED BY cHRISTO

    • Moved by Nan_Yu Tuesday, July 5, 2016 7:00 AM Relate to access
    Wednesday, June 8, 2016 7:01 AM

All replies

  • Hi icewulf,

    This is the forum to discuss questions and feedback for Office 365 for Developers, I'll move your question to the MSDN forum for ACCESS for Developers

    https://social.msdn.microsoft.com/Forums/en-US/home?forum=accessdev 

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, 
    and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. 

    Thanks for your understanding.
    • Edited by Nan_Yu Tuesday, July 5, 2016 7:02 AM
    Tuesday, July 5, 2016 6:59 AM
  • Hi icewulf,

    >> DISPLAY ONLY RECORDS OF STUDENT WHO ARE TRAINED BY cHRISTO

    I think you could try the query below:

    Select * From Student

    Where Trainer=”cHRISTO”

    Best Regards,

    Edward


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.


    Tuesday, July 5, 2016 7:09 AM
  • More information is needed before your question can be answered with any degree of confidence:

    1.  What tables make up the database?
    2.  What are each table's columns?
    3.  How are the tables related?
    4.  Can a student be trained by only one trainer or by multiple trainers?
    5.  If a student can be trained by multiple trainers do you wish to aggregate the hours and fees for only the time the student is trained by Christo, or for the total time trained by all trainers?  My guess would be the former, but as it stands your question is ambiguous in this respect.

    Ken Sheridan, Stafford, England


    • Edited by Ken Sheridan Tuesday, July 5, 2016 11:06 AM Typo corrected.
    Tuesday, July 5, 2016 11:05 AM