USING FORMULAS WITH REPORTS FOR SUM

J

JOCATS1

I am trying to create a report in access 03 that allows me to tota
all balances in the [total_balance] field for all those that hav
been customer for >5 and <11 in the [days] field and then fo
those customers that have had accounts for >10 and <21 [days
and so on
I have been trying to do this in the control source and have had n
luck. I also have created different queries for the different day
open, but when I try to design a report with more than one query i
tells me that wizard can't connect try choosing fields from only th
table or only the query
Any help here would be wonderful
Thank you
Jocats
 
Top