math help

R

rose

My son lists each item of income or expenses in a
Microsoft Access Table and runs a Report with a running
balance. But when he submits the money to the accountant,
she will not, or cannot, list what items from his list are
outstanding.She just gives him a total figure of the
amount that is outstanding. He wants to work with her.
Currently, he looks through the items until he can match
items totaling the difference in his balance and hers. It
worked for him last year. This seems time consuming and
laborious to me. Is there any way a program could do a
search for amounts which would equal a total? We use
Access 2000 but could process a solution in Excel. I wrote
the database for him. I am able to use the functions of
the program readily, but have not attempted to write any.
I use Windows ME
 
L

Larry Linson

It would be easy to select the open (unpaid?) items if there is an
indication in the data. Otherwise, it is just a guessing game as to which
items constitute the "difference"... if there are, say, 6 items with each
having an amount of $4.50 and the difference is $9.00, which _two_ of the
six are the outstanding ones?

No, there's no built-in functionality to do what you want, but you could
write (or hire someone to write) VBA code to read the data and try to come
up with records totalling a particular sum.

The real answer is that you need to keep track of what is/is not an
outstanding item.

Larry Linson
Microsoft Access MVP
 
A

Arvin Meyer

If there are field to record the date of receipt and amount for each item of
income, a simple query to look for null dates, or unmatched amounts will
give you what you need without even bothering with the accountant.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top