subreports or union query
I need to create a report that condenses an takes the average and sum of all of the records divided up into there respected amounts. 0 - 100000, 100001 - 250000, 250001 - 500000......
I have already created 7 queries that have the information I need. Would it be easier to create the report with subreports or to create a union query to combine all of the information. If I use the union query what would the code be. I need FACE_AMT(face amount which is dividing up the info into the 7 groups), Average and sum of face amount, and a count of each which shows how many records are in each catagory.