Thanks for all that responded. It was not a trick or underhanded question. It was just one of those days when I had programmed DCOUNT about a zillion times and I was wondering if there was any shortcut. It's better than the COUNT function that actually counts something different.
I agree that having FOR I=1 to DCOUNT is not a problem with the small counts but dare not consider it as my conscience (the U2 Forum) would frown on it. I've learned a lot from this forum despite my decades of experience as I have not transversed every possible style of coding. My personal collection of styles is gleened from that vast experience of inheriting both good and bad code examples and keeping the best. Thanks Mark Johnson ----- Original Message ----- From: "Bob Woodward" <[EMAIL PROTECTED]> To: <u2-users@listserver.u2ug.org> Sent: Friday, January 06, 2006 11:42 AM Subject: RE: [U2] DCOUNT > Correct me if I'm wrong but does this method not require the DCOUNT > function to be executed each iteration of "I" to determine if you have > reached your max value? Granted, for a small number of values it would > not be that much of a hit but I'd not like to encourage this on the off > chance that you use it on a large number of values somewhere else. > > BobW > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Serguei > Sent: Friday, January 06, 2006 6:02 AM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] DCOUNT > > I personally would even write it like this if I am sure the number of > values > is no more then ten: > FOR I=1 TO DCOUNT(REC<15>,@VM) > > (and of course I would not use number as a field position) > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/