Accounting Reports in Access

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I'm writing a database for a property management company, and I'm trying to
put together individual account sheets that perform regular accounting
calculations needed to show monthly balance/etc. However, what I'm running
into is the Access calculations and formulas are too complex, and do not work
like they would in Excel, where it's easy to put something like this together
with their formula functions. How do I do this?

Basically, I've got all the information entered into a table and I have a
query written to pull out individual accounts, but when I go to put those
into a report that does the calculations, I can't get it to work properly.
.

Quantcast