The query below works, when there are no empty fields in the column Total. If there are empty fields is not working.
query = select INT( Total / 10 ), COUNT(*) from POINT
where Member_Title = 'Mr'
GROUP BY INT( Total / 10 )
ORDER BY INT( Total/ 10 )
Can please anyone tell me how can i do it to work when there are empty fields?
query = select INT( Total / 10 ), COUNT(*) from POINT
where Member_Title = 'Mr'
GROUP BY INT( Total / 10 )
ORDER BY INT( Total/ 10 )
Can please anyone tell me how can i do it to work when there are empty fields?