ACCESS PROBLEM WITH QUESTION

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

Answer 1

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.

Answer 2

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.

Answer 3

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