is a link to a really good way to produce dynamic reports in access using CrossTab Queries as a source.
Does anyone have experience with these??
My question pertains to the subtotals produced in the report footer sections. The numbers are being rounded off to the nearest whole number. Can this be formatted to the nearest tenth?? I suspect it's related to datatypes in the code.
This is for a report for Payroll hours based on Calendar Date on the column fields and the employees as the row headings. Values are hours to the nearest tenth being added.
I'd like to see the totals in the footer section being totaled accurately to the nearest tenth instead of the nearest integer.