Comments by Member 14833529

Member 14833529 16-May-20 2:27am View

Good Day MadMyche,
Thanks for your reply. It is now morning time here in our country. Perhaps there where you are might still be night time. Your reply is valuable. I see that you arranged all amounts under one column. I also understand what you propose. However, having a limitation of knowledge on Access SQL and VBA I cannot add it up as if it was in MS Excel. The table in your reply is the usual Excel table. However, I am not sure whether one can apply it as such. I will copy to you my last trial, last night. It is kind of similar but slightly different.

Member 14833529 15-May-20 15:28pm View

Thanks ZurdoDev.

Member 14833529 15-May-20 15:24pm View

ZurdoDev. I said I tried 1st with 2 different tables, but changed my mind. That is why I tried to do it in one table under different columns and to use a query to calculate deductions (debits) and additions (credits). Maybe its a language barrier which is now at play. Anyway, I really appreciate your valuable efforts to try to help me.

Member 14833529 15-May-20 15:17pm View

Thanks, I tried to illustrate with the copied entries in my reply to ZurdoDev. It is almost the same as for a bank account, where you receive a salary or income and spend; from which you have a running balance which will change as future credits and debits will occur.

Member 14833529 15-May-20 15:12pm View

You made me smile...but, it is true.
The table outlay is as follows:

ID Date_Opened Credit_Details Payment_From (CO) Debit_Details Payment_To (CO) Credit_Amount Debit_Amount
1 13-May-2020 Sales of Heifers; Agra Auction A32055057 Agra None None $21,326.00 000
2 14-May-2020 Refreshments for trip to farm Charney Spar $0.00 (352)
3 14-May-2020 Diesel Shell, Mariental $0.00 (500)
4 14-May-2020 Purchase at Agra, fodder, etc Agra, Mariental $0.00 (5,640)

NB: The first row only has the credited amount of N$21,326. All other rows are having debit entries. I hope it is clear now.

Member 14833529 15-May-20 14:53pm View

Ok. I am sorry. I did not want you to do all the work for me. That is why I explained what I tried to do....and I also looked to similar questions on the forum and tried answers provided. Thanks anyway. I will try to figure it out myself. Kindest regards.

Member 14833529 15-May-20 14:42pm View

1. I have a total budget amount (for a period, eg. 3 months) under its own column and an expenditure column for all expenses. All these are in one table.
2. I have to provide a running balance in my report on how I spent the funds.

Member 14833529 15-May-20 13:16pm View

Hi,
It is a sad situation you are finding yourselves in. May you get assistance, soonest.
I want to propose that you start assisting people with basic programming problems and charge a small fee, such as USD10. You might find that your problem might be over sooner than you would expect. Its just a suggestion.

Comments by Member 14833529 (Top 8 by date)