blomgren Posted January 29, 2004 Share Posted January 29, 2004 I have several repeating fields [field1, field2, fiels3] repeating 5 times and all share a value list: A B C Can I total how many "A", how many "B", how many "C" and then total "A" & "C"? I usually can find the answers just by browsing around here. Thanks! Link to comment Share on other sites More sharing options...
jscooper Posted January 29, 2004 Share Posted January 29, 2004 For each field, I would define repeating calculations for each value you want to check, then a non-repeating calculation counting values in the first field(s). There may be better methods if you have a bunch of values (so you don't have to define 100s of fields), but with only 3, this should work is1A = if(Field1 = "A","Y",""), repeating w/ 5 repetitions is1B = if(Field1 = "B","Y",""), repeating w/ 5 repetitions is1C = if(Field1 = "C","Y",""), repeating w/ 5 repetitions is2A = if(Field2 = "A","Y",""), repeating w/ 5 repetitions is2B = if(Field2 = "B","Y",""), repeating w/ 5 repetitions is2C = if(Field2 = "C","Y",""), repeating w/ 5 repetitions is3A = if(Field3 = "A","Y",""), repeating w/ 5 repetitions is3B = if(Field3 = "B","Y",""), repeating w/ 5 repetitions is3C = if(Field3 = "C","Y",""), repeating w/ 5 repetitions countA = count(is1A) + count(is2A) + count(is3A) countB = count(is1B) + count(is2B) + count(is3B) countC = count(is1C) + count(is2C) + count(is3C) Jeff Link to comment Share on other sites More sharing options...
Vaughan Posted January 30, 2004 Share Posted January 30, 2004 Much better to ditch the repeating fields and go to a related file. Then everything will be easy-peasy. Link to comment Share on other sites More sharing options...
blomgren Posted January 30, 2004 Author Share Posted January 30, 2004 Well... actually I have about 44 fields (weeks of the school year) X 9 layouts (one for each grade level - K-8). I want to enter E-excused, U-unexcused, T-tardy into the repeating 5 fields (one for each day of the week). All was working well while I was just entering "1" for absent. I am not sure what you mean by ditching the repeating fields and creating another file? Link to comment Share on other sites More sharing options...
blomgren Posted January 30, 2004 Author Share Posted January 30, 2004 Vaughan, thank you so very much for the "easy-peasy" related files! I just couldn't wrap my head around this idea... then! BAM!!! I don't have to make 185 fields X 9 class layouts! I just make one year layout and relate students to a Grade1 db, Grade2 db,... I have been struggling with this for sooooooooo long. I took on this job of creating a db for a school district that houses everything! and I am just a wayward housewife with too much time on my hands. This place is so great! Trish Link to comment Share on other sites More sharing options...
Vaughan Posted February 2, 2004 Share Posted February 2, 2004 You could probably simplify even more and make one "grade" database and have a field in it that selects grade 1 or 2. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7389 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