Need a query to get data in access form

[sps]

i have a table 1 attached and want data in access form like table 2 attached



Where RollNo is unique
and i want 1 student per form

i attached da access file

regards

[NoellaG]

you can design a form for students with a subform based on a crosstab query. Be aware that you can view data this way, but won't be able to alter them.

[sps]

Can you tell more about it, access file attached, I will be grateful for your help.

[Welshgasman]

https://www.google.com/search?q=cros...obile&ie=UTF-8

https://m.youtube.com/results?sp=mAE...Crosstab+query

[mike60smart]

Hi
Your query would be along these lines:-

TRANSFORM Sum(exam.[Marks]) AS SumOfMarks
SELECT exam.[Subject], Sum(exam.[Marks]) AS [Total Of Marks]
FROM exam
GROUP BY exam.[Subject]
PIVOT exam.[ExamType];

[sps]

Hi
Your query would be along these lines:-

TRANSFORM Sum(exam.[Marks]) AS SumOfMarks
SELECT exam.[Subject], Sum(exam.[Marks]) AS [Total Of Marks]
FROM exam
GROUP BY exam.[Subject]
PIVOT exam.[ExamType];

thanks I did the query but how I get the data in access form along with RollNo
I NEED ALL SUBJECTS FOR SAME ROLLNO ON SAME FORM LIKE ATTACHED TABLE2

[mike60smart]

Hi
The Form that opens is based on the original Crosstab query. I added the field "RollNo" to the query.

The Format of the Form is now a Split Form
In the header of the Form is an Unbound Control which allows you to enter the RollNo required.
Once you have entered the Roll No - Tab out of the Control and the Records will be filtered to the required RollNo.
Press the Clear Button to display all records.

[sps]

thanks for your help. basically I want result card like attached table(result card) for all students

[mike60smart]

Hi
Without seeing your database it would be impossible for us to make a guess as to your table structures.

[sps]

Hi
Without seeing your database it would be impossible for us to make a guess as to your table structures.

database file is attached

[mike60smart]

No database attached

[Welshgasman]

No database attached

O/P put it in their initial post Mike. Confusing I know.

[mike60smart]

Hi WGM

Yes i got his original database but his last request was to produce details of Students Exam Results.
His original database does not include this data so was asking for the additional tables to be included.

[Welshgasman]

Hi WGM

Yes i got his original database but his last request was to produce details of Students Exam Results.
His original database does not include this data so was asking for the additional tables to be included.

OK, my mistake. Sorry.

[sps]

any chance??