Decimals and SubReports

[LMB]

Hello,

Using Access 2000.

I have a report that has calculated numbers. The calculations are done in a
query. I have set the decimals to 2 in my report. For one set of numbers
this works well but for the number which is an average of the first set of
numbers, I get 12 decimal places instead of 2 that I also have set in the
properties for this number. I also set the decimal to 2 in the query and I
get more than 2 decimals.

My other problem is I have 2 subreports on this report. If there is no data
for the subreports, it prints out on one page. If there is data, I get a
new page for each subreport. How can I get it to continue on the first page
and just continue on page 2 and 3?

Thanks,
Linda

 

[LMB]

Got it. I changed the format of the control to Fixed and the decimal issue
got fixed. I also figured out that I needed to set up the grouping in the
subreport, not on the main report.

Linda