By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,734 Members | 855 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,734 IT Pros & Developers. It's quick & easy.

Access 2000 query syntax using DSUM function

P: n/a

New to this group, so greetings all!

I am trying to develop query syntax in Access 2000 to accomplish the
following:

Imagine you are in an accounting dept. and you are working on a
reconiliation of debits and credits.

Say you have a table / list that is 1000s of lines long. These could
be either debits or credits. Then imagine you know that a certain
combination of these numbers (could be 5, 10, 50 or any number of
lines) equal another (a total) item, that would be the offsetting
debit or credit that is not in the list / table.

I have tried several times writing a query that would find the
combination of debits/credits in the table that equal the known
offsetting debit or credit without success. I would imagine a query
is needed for each offsetting debit or credit, or the original query
would be re-used by changing the original plugged in debit or credit.

I have looked in other online forums, books, and consulted other
Access users with more experience than I without luck. Currently, I
think I am heading in the right direction using the DSUM function, but
all the examples that I have found via Google are just variations of
the canned MS-Access help.

Can anyone provide any help / direction with this problem? It would
be greatly appreciated.

Thanks!

Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.