 | |
Counting records, then add different unique values each semesterreport.
comp.databases.filemaker comp.databases.filemaker
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Counting records, then add different unique values each semesterreport. -
03-11-2011
, 01:08 PM
#2
| |||
| |||
|
|
I have a database of students from a variety of courses. For most of them, we have 1 record per student in a course each semester, so I would have for example: 16 bisc, 14 econ, 10 soci for a total of 40 records. In the annual report, it would list the 40 students. However, now we have to add in that report the dental students. I don't have any info of them, just a different number. This year was 70, last year was 45, or whatever. How can I add that number to a field each year so it gets counted in with the proper semester? Essentially, it would make 41 records, where 40 of them were individual counts added up, and then 1 record of a value. My final report would be sorted by semester, so we could track progress of how/where students volunteer. |
"... respect, all good works are not done by only good folk. For here, at the end of all things, we shall do what needs to be done."
--till next time, consul -x- <<poetry.dolphins-cove.com>>
#3
| |||
| |||
|
|
I have a database of students from a variety of courses. For most of them, we have 1 record per student in a course each semester, so I would have for example: 16 bisc, 14 econ, 10 soci for a total of 40 records. In the annual report, it would list the 40 students. However, now we have to add in that report the dental students. I don't have any info of them, just a different number. This year was 70, last year was 45, or whatever. How can I add that number to a field each year so it gets counted in with the proper semester? Essentially, it would make 41 records, where 40 of them were individual counts added up, and then 1 record of a value. My final report would be sorted by semester, so we could track progress of how/where students volunteer. |
probably easiest to simply add a new record for EACH Dental student in each
semester (i.e. 70 dental students this year, so add 70 records) - they would
have the appropriate semester / date, but could all be just named "Dental
Student". (Once you've created one record you can Duplicate it to save
retyping the name and semester / date details.)
This would make it easy for producing a report using Summary fields and
layout parts to give a report like:
SEMESTER 1
Bisc 16
Dental 70
Econ 14
Soci 10
Total 110
SEMESTER 2
...
Helpful Harry
)
#4
| |||
| |||
|
|
"~consul"<consul (AT) dolphinsTAKEAWAY-cove (DOT) com> wrote in message I have a database of students from a variety of courses. For most of them, we have 1 record per student in a course each semester, so I would have for example: 16 bisc, 14 econ, 10 soci for a total of 40 records. In the annual report, it would list the 40 students. However, now we have to add in that report the dental students. I don't have any info of them, just a different number. This year was 70, last year was 45, or whatever. How can I add that number to a field each year so it gets counted in with the proper semester? Essentially, it would make 41 records, where 40 of them were individual counts added up, and then 1 record of a value. My final report would be sorted by semester, so we could track progress of how/where students volunteer. If there's already one record per student in each semester, then it's probably easiest to simply add a new record for EACH Dental student in each semester (i.e. 70 dental students this year, so add 70 records) - they would have the appropriate semester / date, but could all be just named "Dental Student". (Once you've created one record you can Duplicate it to save retyping the name and semester / date details.) |
Thanks for the reply though.--
"... respect, all good works are not done by only good folk. For here, at the end of all things, we shall do what needs to be done."
--till next time, consul -x- <<poetry.dolphins-cove.com>>
#5
| |||
| |||
|
|
I was hoping that wouldn't be the case, I tried that and it's "annoying" Thanks for the reply though. |
--
"... respect, all good works are not done by only good folk. For here, at the end of all things, we shall do what needs to be done."
--till next time, consul -x- <<poetry.dolphins-cove.com>>
#6
| |||
| |||
|
|
'tis on Fri, 11 Mar 2011 13:31:13 -0800, wrote ~consul thus to essay our thoughts to discern upon I was hoping that wouldn't be the case, I tried that and it's "annoying" Thanks for the reply though.Should have clarified, it is annoying because they gave me about 50 semesters of additional "Dental Students" to include in the count. |
in the long run for the reports, etc., especially if you can keep it more
up-to-date in the future.
Using the Control D keyboard shortcut to duplicate the record means it
won't take too long.
You could create a simple Script to duplicate the current record X number
of times, where it gets X from a Global field, then it's just a matter of:
- create one record for the first semester / date
- change the Global field to however many records you need
for that semester and then run the Script
- create one record for the second semester / date
- change the Global field to however many records you need
for that semester and then run the Script
- etc.
Then you're only creating 50 records and running the Script 50 times.
Or you could use Excel and its Fill Down command to quickly create
duplicate rows, and then import that file into the FileMaker database as
records.
BUT,
however you do create those records, make sure to spend a bit of extra
time afterwards double-checking that you've got the correct number for
each semester! It would be easy to be one or two records out somewhere.
Helpful Harry
)
#7
| |||
| |||
|
|
I have a database of students from a variety of courses. For most of them, we have 1 record per student in a course each semester, so I would have for example: 16 bisc, 14 econ, 10 soci for a total of 40 records. In the annual report, it would list the 40 students. However, now we have to add in that report the dental students. I don't have any info of them, just a different number. This year was 70, last year was 45, or whatever. How can I add that number to a field each year so it gets counted in withthe proper semester? Essentially, it would make 41 records, where 40 of them were individual counts added up, and then 1 record of a value. My final report would be sorted by semester, so we could track progress of how/where students volunteer. -- |
Add a quantity field to the table. Have it auto-enter 1, but you
should be able to change it to 40 if necessary. Sum on that field.
DJ
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.