Need a query to get data in access form

[mike60smart]

Hi you need to upload your full database that contains the Student table and all related tables.

[sps]

Hi you need to upload your full database that contains the Student table and all related tables.

file is attached there are only two tables
students
exam

[mike60smart]

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.

[sps]

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.

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 ok

[mike60smart]

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

[sps]

Thanks
is it possible to get require result in access form (one student per form) or we must create report for that???

[mike60smart]

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.

[sps]

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.

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 out

[mike60smart]

My original post told you how to do this.

Carry out the steps indicated and then upload what you have done.

[sps]

in your first post there is crosstab query plz help further

[mike60smart]

Hi
See rptStudentsExams in the attached

[Welshgasman]

Now crossposted at https://www.access-programmers.co.uk.../#post-1883809

[sps]

Hi
See rptStudentsExams in the attached

dear bro its not what I required

is it possible to get each student result in separate form page so I can print each student separately
there should b less or more assessments.