how come my ms chart doesn't realise that i have a record with a field value of "a". I use this SQL to open the recordset:
adoRecordset3.Open "Select Name, Count(*) as How_many_times_name_appears from reportertb1 Group by Name Order by Name", db, adOpenStatic, adLockOptimistic
When is set the chart's datasource to adoRecordset3 it graphs all the names except for "a" and yesterday it wouldn't graph one named "afd".
Its a puzzler
Thanks for any help you may be able to give
adoRecordset3.Open "Select Name, Count(*) as How_many_times_name_appears from reportertb1 Group by Name Order by Name", db, adOpenStatic, adLockOptimistic
When is set the chart's datasource to adoRecordset3 it graphs all the names except for "a" and yesterday it wouldn't graph one named "afd".
Its a puzzler
Thanks for any help you may be able to give
