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

Reply via email to