I can wait a little longer.
I highlighted the data and then did insert, pivot table and created a pivot table and chose some basic fields. It does appear to group it by student, but it's not in a very readable format and I don't know enough about pivot tables to make it readable. It also has the big blank box that says "Drop column fields here" and "Drop data items here". I don't know what to do with that. Can you please give me the step by step on how to turn it into a readable report. The file number is XXXXX Thanks!
Yes. I started with the id field, which is displayed in the 1st column on the left. Then I dragged the course title field into the "drop data items here" block. It creates another column just to the right of the id column, but the new column takes a heading of "Total" and just displays a count of the number of courses each student is failing. How do I get it to display the course title(s)(plural for those failing multiple courses) all on one row?
Can't download it. When I put the mouse on the link, it changes color to orange and doesn't give me the pointer to click on the link.
That's not what I'm looking for. If you go back to the original spreadsheet and look at the first 2 lines. The student's name isXXXXX and he's failing 2 courses(ENGL 102 and PECS 110). I want the pivot table to combine these 2 lines into one line that lists all of his personal information, then lists both courses(with other info about each course) back to back, reading from left to right, on the same line with his personal info. I want only one line per student, even if they're failing multiple classes. If it can't be done by a pivot table, it could be done using MSAccess if you know how.
Yes, but unless it's just a matter of me not knowing how to use it, I don't think it solves my problem. When I open it, I see the 2 forms and I can put in an id # XXXXX the fmain form and it looks up some information for the student. If I open the other form, it displays the courses and id, but it still has multiple lines per student. Is there something I'm supposed to do to make it display all the information for a student on one single line?
This all comes from MSAccess macros and queries that pull this data from oracle tables and generate the report in Access. I think you may be on the right path by separating the data into 2 tables and then querying the two tables so that it generates 1 line of output per student, even if that student is failing(or in danger of failing) more than 1 class, but I need to know how to put this in the original query, so when the user runs it at midterm, it automatically does all the steps to produce the output they are looking for. Let me know if you need to see any of the queries or macros that we run.
Yes. When I go to the 2nd record(Josh Pittman), it displays 2 lines for him with fields ID1,Campus,id,AS(blank),CL,GST(Blank),Private,Action(Blank),PS1(Blank) and part of PS2(Blank). Are you saying that if i remove the empty columns, that it will pull the rest of Josh's information onto 1 row(or record), instead of spreading it over 7 or 8 records? If so, how do I delete a column that's blank?
As a side note, I'm not sure that i will be able to remove these fields from the users report, b/c even though they may be empty columns for the students selected for this semester, students selected in subsequent semesters may have information attached to their records that belongs in these empty fields. Thanks!!
I went into the Grades table and removed the blank columns. Do I have to go into the Names table and remove the rows that only have information in 1 column?. For Josh Pittman in the names table, I need to manually delete 6 rows?