[Babase] Query to assist in finding incomplete censuses

Karl O. Pinc babase@www.eco.princeton.edu
Tue, 12 Jul 2005 19:37:18 +0000


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