The printed results should be correct. If you go page by page through the
report the preview results should also be correct. If you just skip
immediately to the end, you could end up with a discrepancy. Access doesn't
run the code to create each intermediate page.
The report is a single page report. The VBA code is in the report to run a
YTD total across the page. It works great for the first couple of years, but
in 2005, since there is no data for Nov and Dec., it gives the answer for
the previous year.
What's the code? What is the data and how is it stored/accessed? It is
difficult, at best, to debug remotely; with only general information, it is
not possible.
Larry Linson
Microsoft Access MVP
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
