Hello Richard For me it looks you want use "Group By" instead Unions in SQL to get the Resultset like
> xaxes-text|count|display_order > ------------------------------------------- > 5-6 5 1 > 6-7 100 2 > over 7 10 3 > And to deal with Number vs Text you could use Regexp in MySQL (maybe other SQL engines too) > select > reference_range as XAxes_text, > ,count (value) as count > ,@row:=...@row+1 as display_order > From (SELECT @row:=0) as r, clin_requests.vwResults > Where value RegExp '[0-1]' > Group by reference_range > Just as idea. Regards, Werner(007) -- View this message in context: http://www.nabble.com/Help-with-converting-text-in-field-to-number-tp21675635p21796806.html Sent from the gambas-user mailing list archive at Nabble.com. ------------------------------------------------------------------------------ This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user