baseportal | ||
Start | ||
baseportal message board | |
Welcome to the baseportal message board... Please read the FAQ.
|
Selected message: | To the list |
Message from TheOneRing on 1/4 2004, 00:22 +00:00 EMail: theonering@thegateroom.com WWW: geocities.com/theonering_stargate Thanks Christoph - It works!:) |
|
All messages from this thread: | To the list |
Message from TheOneRing on 1/3 2004, 05:53 +00:00 EMail: theonering@thegateroom.com WWW: geocities.com/theonering_stargate Really need help here - perlI need to sum the total of a field IF it meets certain criteria. My database looks a bit like this: Title (field) Chapter (field) Size (field) My Life .......... 1 ................ 5 My Life .......... 2 ................10 My Life .......... 3 ................ 8 The Revenge.....1 ..............30 The Suspect.....1 ..............10 The Suspect.....2 ..............20 I need to sum the field "Size" IF the field "Title" is the same story title. But, obviously I don't want to query the actual field value...too many entries. So I have to use variable names like $Title and $Size. In the example above, my sums should be: For My Life Sum=23 The Revenge Sum=30 The Suspect Sum=30 It sounds like it should be easy enough but I've been playing with it for weeks and can't get what I need. Any help would be appreciated. Thanks, TheOneRing |
Message from Christoph Bergmann on 1/3 2004, 18:12 +01:00 EMail: info@baseportal.com Re: Really need help here - perlTry this:
;-)) |
|
Messages from 2850 to 3000: | To the input form |
> Really need help here - perl from TheOneRing on 1/3 2004, 05:53 +00:00 Re: Really need help here - perl from Christoph Bergmann on 1/3 2004, 18:12 +01:00 |
Thanks Christoph - It works! from TheOneRing on 1/4 2004, 00:22 +00:00 |
<< Newest messages | < Newer messages | To the input form | Older messages > | Oldest messages >> |
© baseportal.com. All rights reserved. Terms of use |