OK thanks folks. Here is the full query (which is why I can't use WHERE clauses! It has always worked before...... I have removed the double-quoted but it makes no difference.
SELECT COUNT( "Year2007" ), COUNT( "Year2008" ), COUNT( "Year2009" ), COUNT( "Year2010" ), COUNT( "Year2011" ), COUNT( "Year2012" ), COUNT( "Year2013" ) FROM "Members" On 16 September 2012 17:48, Bart Smissaert <bart.smissa...@gmail.com> wrote: > Hi John, > > Funny seeing you here on the SQLite forum. > Are these by any chance the ISUG members? > Doing a count without a WHERE clause is always likely to give different > results > with the various SQL implications as far as I know. > Why not add a WHERE? > > RBS > > > On Sun, Sep 16, 2012 at 5:17 PM, John Clegg <john.cl...@nailsea.net> > wrote: > > I have a table Members with 896 rows and a text field "Year2012". It > > contains "Paid" 156 times, "Comp" 13 times and the rest are null > (confirmed > > in sqlitebrowser as "empty") > > > > Back in the olden days when this table was in Access, select > > count("Year2013") from Members used to return 169. In LibreOfiice with > the > > data stored in embedded HSQL it returns 169. In LibreOffice connecting to > > sqlite3 it returns 896. > > > > Any ideas please? > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users