I am currently programming with vb4 and use access 2000 as the db and crystal reports to display reports, my question is I have a query that deals with payroll, I have reg.pay, overtime, and the total of those two; but I am having trouble getting the grand total of each, crystal and access state that I am not able to sum that field; if you need more info please let me know..?