Note use of Cen flag, which indicates census row is from census sheet. select date, count(*) from census where grp = 1.1 and cen and date >= '2001-07-1' and date <= '2002-02-01' group by date order by date desc; Karl <kop@meme.com> Free Software: "You don't pay back, you pay forward." -- Robert A. Heinlein