Solved DYNAMIC REPORT FROM CROSSTAB QUERY (1 Viewer)

[I am alive]

draw in a paper the report you need and take a snapshot and post.

 

[arnelgp]

will this report do for you?

 

[mike60smart]

Hi
Is the attached screenshot the Report Layout you are expecting?

Looks like Arnelgp beat me to it with a much neater looking final report

 

[I am alive]

will this report do for you?

I had developed this before and it is good when giving each student report form. But now i want it to be across just like in ms excel. With this alot of printing papers will be used. I need papers to be minimized by developing a report from crosstab query just like in qrygrades query. I am defeated. I have searched all over the internet.

 

[mike60smart]

If you display the Grades Horizontally then you would end up printing even more paper.

 

[I am alive]

Hi
Is the attached screenshot the Report Layout you are expecting?

Looks like Arnelgp beat me to it with a much neater looking final report

Not this. Should look just like in ms excel. Subjects to be across.

If you display the Grades Horizontally then you would end up printing even more paper.

Let's use subjectID in subjects table then.

 

[I am alive]

Not this. Should look just like in ms excel. Subjects to be across.
Let's use subjectID in subjects table then.

subjectID is the best
E.G
ENG KIS MAT BIO PHY GEO TOTAL
70. 70. 70. 70. 70. 70. 420

 

[mike60smart]

This is what it looks like Landscape

 

[I am alive]

This is what it looks like Landscape

If you delete the records in studentsubjects table it creates an error in report. My database will be used by different people and I will have to reset everything in tables. Basically, it will create an error. I believe there should be a function to increment the description by 1 and also subtract by 1 when selected and deleted respectively. I know in this forum we have expertise in ms access functions and queries. Otherwise I appreciate the work you people are doing.

 

[Gasman]

If you are resetting all the time, you are going about it the wrong way.

 

[I am alive]

If you are resetting all the time, you are going about it the wrong way.

It has to be reset sir. What if a student is allowed to drop a certain Subject. Also not all institutions offer the same subjects. A subject can be removed after some years. It happens. The database should accommodate. There should be a way.

 

[mike60smart]

You would manage this by adding a field to tblSubjects to indicte if the Subject is Active / Not Active.

Then your Combobox for selecting a Subject would be filtered to only show those Subjects that are Active.

 

[I am alive]

You would manage this by adding a field to tblSubjects to indicte if the Subject is Active / Not Active.

Then your Combobox for selecting a Subject would be filtered to only show those Subjects that are Active.

Kindly assist me in using the above database please I beg you

 

[theDBguy]

Kindly assist me in using the above database please I beg you

Hi. Which "above database" would that be? Which post #?

 

[mike60smart]

Kindly assist me in using the above database please I beg you

Do you want me to add the additional field to tblSubjects ?

 

[I am alive]

Hi. Which "above database" would that be? Which post #?

 

[I am alive]

Do you want me to add the additional field to tblSubjects ?

Yes. I will appreciate

 

[mike60smart]

Yes. I will appreciate

Hi
Which of the Subjects are no longer Active?

 

[I am alive]

Hi
Which of the Subjects are no longer Active?

Oh oh. All are active now for sometime. Then they are being dropped by Students selectively. It cannot be specific

 

[mike60smart]

Your Report will not work using the method you are suggesting.

If you want it to be dynamic and only show those subjects which are active then you cannot use a Crosstab and the subjects would have to be displayed Vertically.