and it worked! Unbelievable what R:Base can do. That's one wild HAVING
clause in my books. I'm retrieving data from an Access 97 system that
died for my church. This is to replace non existent "joined the church
date" dates. Whoever wrote the A97 system was in love with DATETIME when
DATE is all the information there ever will be. Had a bunch of NULL
dates show up without the HAVING clause.
SELECT PersonId,MIN(DEXTRACT(DonationDt)) +
FROM xDonation +
GROUP BY PersonId +
HAVING MIN(DEXTRACT(DonationDt)) IS NOT NULL
R:Azzak, your team is terrific
Albert
--
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
