hi brothers
i need your help to retrive values from access db
to be shown in the MSFlexGrid and the sql statement which i want to use is
 = "select orgtype, sum(estab), sum(mem), sum(gtotel), sum(exec), sum(comm),sum(oexp), sum(ntotel) from pay group by orgtype"

please help

Well, once the S.Q.L. has`retrieved the specified fields, with or without calculations you need to program the flexgrid to output the record(s) from the relevant recordset in memory.liamfitz.good luck.