I volunteer at a local charity, the database that they are currently using is placing the donations and bank deposits on the same line and many problems are occurring.

The accounting lady wants;
line - 1 - to show the donations
line - 2 - to show the bank deposit and the applied amount

Sometimes Donators give multiple donations and make one payment to cover their offering.

Could I have suggestions on how to create separate lines for each data entry?

Could I have suggestions on how to create separate lines for each data entry?

you could get a lot of them if you provided the information needed. like:

show us what's happening now
upload a database to show us
how is the data entered?


in a simple answer, the way to get both numbers on different lines is to enter two records instead of one. THAT'S IT. if you tell us WHY you can't do that (which i'm sure you can't for obvious reasons), then I assume more help will follow on how ELSE to do it

I will ask the charity to allow me to upload their data base when I visit them on Tuesday.

They are now using one form in entering their records to one line using the Donation# - UC0052 to book the Donation and the same line is appended by am other form to apply the deposit.

This one line of entries is not working and I agree with the accountant that two lines are required.

This one line of entries is not working and I agree with the accountant that two lines are required.
Two lines are not required. Most likely two tables are required.

The one table for booking the donation and then the other for receipts. That way you can have as many receipts as necessary and a query can pull together the amounts paid and tell whether you have a balance outstanding or not.

Thank you for your suggestion.

My thought was that two lines should be used and you have now pointed me in a new direction that was never thought of, I will try this on Tuesday.

Thankssssssssssssssssssssssssss