(no subject)
Mar. 23rd, 2001 01:23 pmScotto, don't forget.
SELECT rpr0324.NAME, rpr0324.OFFICE, rpr0324.SEQ, rpr0324.PREFIX, Count(rpr0324.PREFIX) AS CountOfPREFIX
FROM rpr0324
GROUP BY rpr0324.NAME, rpr0324.OFFICE, rpr0324.SEQ, rpr0324.PREFIX
HAVING (((rpr0324.NAME)="Jennifer Poole"));
simplicity is what matters. Jenny will be much happier, as a result.
SELECT rpr0324.NAME, rpr0324.OFFICE, rpr0324.SEQ, rpr0324.PREFIX, Count(rpr0324.PREFIX) AS CountOfPREFIX
FROM rpr0324
GROUP BY rpr0324.NAME, rpr0324.OFFICE, rpr0324.SEQ, rpr0324.PREFIX
HAVING (((rpr0324.NAME)="Jennifer Poole"));
simplicity is what matters. Jenny will be much happier, as a result.