Hi you need to upload your full database that contains the Student table and all related tables.
Hi you need to upload your full database that contains the Student table and all related tables.
You can PM me if you need further help.
Good Reading https://docs.microsoft.com/en-gb/off...on-description
Hi
You have not set any relationships between the 2 tables.
A Student can take 1 or More Exams.
Students table has an Autonumber PK named "ID" this should be changed to be "StudentID"
Your Related table should contain a FK named StudentID so that you can link the 2 Tables and Enforce Referential Integrity.
You are then able to create your Crosstab Query.
You can PM me if you need further help.
Good Reading https://docs.microsoft.com/en-gb/off...on-description
I did add the fields/rename and make a relation 1 to many, please check the attachment and let me know if this step is okHi
You have not set any relationships between the 2 tables.
A Student can take 1 or More Exams.
Students table has an Autonumber PK named "ID" this should be changed to be "StudentID"
Your Related table should contain a FK named StudentID so that you can link the 2 Tables and Enforce Referential Integrity.
You are then able to create your Crosstab Query.
Hi
OK In the attached I have added a Query named "qryStudentsExams"
This produces the data in a Crosstab
What you now need to do is create a Report based on the query that would display for Each Student their Exam Results
You can PM me if you need further help.
Good Reading https://docs.microsoft.com/en-gb/off...on-description
Thanks
is it possible to get require result in access form (one student per form) or we must create report for that???
Well it all depends on what you want Access to do for you.
You can create a Form based on your query.
You can set Criteria in the query that allows you to filter for a specific Student.
You can then add a Command button to the Form that allows you to generate a Report based on
the current Record shown on the Form.
You can PM me if you need further help.
Good Reading https://docs.microsoft.com/en-gb/off...on-description
Basically I want to print each student card separately like attached. if there are 1000 student I want to print them with one print command . How do I figure outWell it all depends on what you want Access to do for you.
You can create a Form based on your query.
You can set Criteria in the query that allows you to filter for a specific Student.
You can then add a Command button to the Form that allows you to generate a Report based on
the current Record shown on the Form.
My original post told you how to do this.
Carry out the steps indicated and then upload what you have done.
You can PM me if you need further help.
Good Reading https://docs.microsoft.com/en-gb/off...on-description
in your first post there is crosstab query plz help further
Hi
See rptStudentsExams in the attached
You can PM me if you need further help.
Good Reading https://docs.microsoft.com/en-gb/off...on-description
Now crossposted at https://www.access-programmers.co.uk.../#post-1883809
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba