J
John
Newbie here...
Is there a way to import data from a MS Query "vertically" instead of
"horizontally?" I'm trying to import student names, month names, and
monthly grade average (for each student, sorted by name, and month).
Ex:
Name, Month, Avg
John Doe, Jan, 90
John Doe, Feb, 88
....
Jane Doe, 2003, Jan, 85
Jane Doe, 2003, Feb, 98
BUT, instead of having each student's monthly average placed in a row,
have it placed in columns with only one row/student. So:
Name, Jan (avg), Feb (avg), Mar (avg)...Dec (avg).
John Doe, 90,88...
Jane Doe, 85, 98...
I understand there will be problems with thus, such as some months
having no data. I'll hopefully figure that out later. I just need to
know if I need to design the query to do this somehow, or if I need to
write a macro to reorganize the data after the import.
Any help is appreciated!
Is there a way to import data from a MS Query "vertically" instead of
"horizontally?" I'm trying to import student names, month names, and
monthly grade average (for each student, sorted by name, and month).
Ex:
Name, Month, Avg
John Doe, Jan, 90
John Doe, Feb, 88
....
Jane Doe, 2003, Jan, 85
Jane Doe, 2003, Feb, 98
BUT, instead of having each student's monthly average placed in a row,
have it placed in columns with only one row/student. So:
Name, Jan (avg), Feb (avg), Mar (avg)...Dec (avg).
John Doe, 90,88...
Jane Doe, 85, 98...
I understand there will be problems with thus, such as some months
having no data. I'll hopefully figure that out later. I just need to
know if I need to design the query to do this somehow, or if I need to
write a macro to reorganize the data after the import.
Any help is appreciated!