LiveOak Posted February 1, 2001 Share Posted February 1, 2001 How about a little more information about the structure of your files. There are seldom "universal" answers, we need more details! -bd Link to comment Share on other sites More sharing options...
susan Posted February 1, 2001 Share Posted February 1, 2001 I'm writing a solution that will compute how many credits a student still needs in each of the required areas. For example, it will tell me that Mary has 3 English credits and so needs 1 more. I have the data entered and with a sub-summary I can determine that Mary has 3 English, 2 Science, etc. I also have a field storing how many credits from each area is required. (EnglishRequired holds 4) My question: How do I get the data of the number of credits for each required area already received into a field so I can subtract it from Required field or each area to get the number still needed? I think I need to use SetField along with Loop, but I don't know how--things I've tried so far haven't worked. thanks for any help. Susan Link to comment Share on other sites More sharing options...
dspires Posted February 1, 2001 Share Posted February 1, 2001 Create a self-join relationship in the database, based on student ID, for instance. Then you can create a summary field for total credits received based on that relationship. Let me know if you need more details. Link to comment Share on other sites More sharing options...
susan Posted February 2, 2001 Share Posted February 2, 2001 OK, a little more info is a good idea... I am importing the credit information (student name, course taken, and credit given) from the schools record keeping software (which also creates the transcripts.) Each course comes over as a separate record. I have a calculation field which looks at the course taken (Current Events, for example), and determines what area it belongs to (in this case, Social Studies) I have a summary field which totals the credits and, in a sub-summary part, totals the credits for each area. But I need to subtract this total from the total number of credits per area needed to graduate. Additionally, any credit over the number needed in any area is considered an elective. For example, they need 3 social studies credits and 15 elective credits. If they take 4 social studies credits, one of them is counted as an elective. Please post again if I can clarify any further. Thanks for any help. Susan Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8484 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now