Make a query,Q1, to sum the columns, (use NZ(field) to convert nulls to zero)
then make a query Q2, that uses Q1 to divide the 2 sums.
select sum(nz(time1)), sum(nz(time2)) from table
dear ranman256
thanks for your help.
but my problem is not turning nulls to zero
my problem is how to work with the sums
I have added the total row to my query but I do not know how to work with them and divide them
is there any way to mention them (total row numbers) in VBA?