Hi John, If you zip the file (it sounds it is only small) and mail it to me or to this list and tell what answer you want I (or somebody else) will post the SQL.
RBS On Mon, Sep 17, 2012 at 7:59 AM, John Clegg <john.cl...@nailsea.net> wrote: > 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users