How to Combine multiple records into 1???
Hi all. I'm trying to figure out a solution to the following task. I've got a table with fields similar to the following:
Right now to data that's imported is in the following format (6 records).
A - Math -3
A - English -4
A - Science -3
B - Math -2
B - English -3
B - Science -3
What I'm trying to accomplish is to get the data into the following format (2 records):
Student Math English Science
A 3 4 3
B 2 3 3
I've thought about using Cross-tabs but would appreciate other sugguestions/solutions.
Thanks in Advance
In order for other forum participants to better help you, please provide the following information when posting:
1. The version of FileMaker Pro you are using: FMP10
2. The operating system and version you are using: Windows XP
3. Describe as much detail about your database as is pertinent to your question. Otherwise, other forum participants will have to guess and/or ask for more information.
5. Try to indicate your level of experience with FileMaker and/or other database designs. If the person responding to your post knows that you are a newer user, they can give a more detailed step by step description:Moderate