am doing one project using vb6.0+access+crystal report8.5

some error occur during the crystal report.

Query Name

seqquery: SELECT segment_trans.division_name, sum(segment_trans.Total_value) AS total, division_master.Target FROM segment_trans, division_master GROUP BY segment_trans.division_name, division_master.Target;

crystal report percentage formula:

{(seqquery.total * 100) / seqquery.Target }

Error: This field name is not known.

note: Total_value and Target field's datatype "Text"

how to solve this ?

please help me.

Thanks

Sathik