Advice - getting data filtered to generate report

[ss188]

Hello all

I wonder if anyone can help me/point me in the right direction.

I have a large dataset which has data about students in a school. Each student is in several classes. What I need to do, and am struggling is to filter the students for each class then populate a report with that group of students. I have over 100 classes so need to automate this process. I am really struggling with how to filter the data and then place it within the report. I need the whole process automated.



Here is some example data -

name	Grade	Grade	Class 1	Class 2	Class 3	Class 4
xx	2	3	8G	8F	8D	8M
xx			8J	8G	8E	8J
xx			8E	8S	8G	8G
xx			8S	8J	8E	8K

This s a small sample of the data. I need to select the students for each class then populate a report with that data for every class I have. Any pointers would be really helpful.

Regards

[ranman256]

your data is designed wrong. Relational databases use normalized records. Yours should be:
Name, Grade,Class
xx, 2, 8g
xx, 2, 8f
xx, 2, 8m

queries then collate and report data from this.

[ss188]

Sorry, thanks for the advice but I don;t think I explained myself correctly. The problem I have is that I get the data from another system in this format. Unfortunately I cannot get it out any other way so have it in a flat file in the first instance. I need to be able to get it in a format that I can use but not sure how to automate this.

Regards

[andy49]

You could put the data in a temporary table then "sort it " into the correct table structure using sql/vba. Easier to work with from there.


Sent from my iPhone using Tapatalk