Record Arrange by "ID"

[smtazulislam]

In the attached picture I have still Data in the YELLOW label.
I would like arrange to GREEN color table for display in Query and Report. I don't know, it possible in access.

Need experts opinion....

 

[arnelgp]

you create a Query between transfer and expense table.
Joining transfer.transferID with expense.transID.

 

[smtazulislam]

@arnelgp thnak you very much for your comment. Hello Sir, Before my data in the excel file Now I arrange in the access. Its my personal Cost for using this dB. Family members Cost review Like, My parent, sister, brother, my son and family other member is study, I have to send money every month ONE or TWO Bank account.
then they're transfer to each members who need money.
so, I want to keeping record for every single cost. Hope you understand

As per first message, I just add one more table "tblWithdraw" Because to know each Bank Account Balance.
My main 3 tables, tblTransfer , tblWithdraw , tblExpensive.

 

[isladogs]

For info, you can hide the repeated values in a report, but not in a query

 

[smtazulislam]

I don't see any relationship between the two tables.

thank you very much for your comments....

Here I mentioned by numbers for relations to each others. Hope you understand.....

unless the join is BeneficiaryID to MemberID. But then the result table doesn't make any sense. Please tell us how the two tables are related.

I change the relationship between tblWithdraw and BeneficiaryID.
Is this okay ?

 

[smtazulislam]

You might want to rethink your schema. Members and beneficiaries should be ONE table not two. People are people. You would not have a Withdraw table.

Hello Sir, Thanks for your comment and advice.
Here is one think. Beneficiary 5 accounts only. In the future maybe to added more. I will transfer money to nearest beneficiary for giving hand cash.
Then they're reply to me the total cost descriptions. Actually my family 6 members is students And 4 is study in college . So, specially I want to know, where their are expense sending money. Because, I can't take-care of both
But Member is day by day increase. Before member is 5, now it was 9. And many members is not open account.
So that I put like that..
Any suggest this issue.

 

[smtazulislam]

1) qryTotalCostByExpenseType
2) qryBankAccountBalanceByMembers
3) qryTotalExpenseByMembers
All of the query would like to update in the tables.

 

[smtazulislam]

1. Balances do not need to be stored. They should be calculated on the fly.

I would like to display in the current record when I will entry data in the expense

2/ Date is the name of a Function. Do NOT use the names of functions or properties as column names. What do you think will happen if you type Date in code? Will you get today's date or will you get the date of the current record?

I get it. All I have change but forget to change in the table tblExpenseDetails.

3. Your table design allows for only ONE bank account per person. Inflexible and unnecessary.

My two members is one person in three banks 3 accounts. All of you it. They are the problem when you transfer to the same bank then you get a free transfer. But If you do have not the same bank you will pay the transaction fee. So I would like it.

4. What is the purpose of ExpenseDetails? I thought this app was just to track transfers between individuals. Same question about Withdrawals. Both would be transactions. All transactions should be in a single table so you can sum them easily to get a current balance.

I have explained in msg #8. My many members is students. They need it every month money. Some students are not allowed to open an Account. They use subAccount from their mother and with a legal bank "Power of Attorney ".
So, They withdraw money from ATM. Their mother should know how much money they withdraw and how much balance they have in their subaccount.

Transaction types:
Deposit
Withdrawal
Transfer

All have From and To attributes.

NONE of your "to" tables have a "to" attribute

If you want to keep an actual general ledger, buy the cheapest version of Quicken you can find. It still allows for multiple accounts and will actually manage the account actions.

This part I don't know what is you exactly explain to me. I think you talking about UNION.
If right! Actually, I want history form to know all about a member ALL TRANSACTION & EXPENSE.

If you have a better Idea ! can you edit or give a demo.

 

[smtazulislam]

One of my good friends didn't like the way her husband balanced the checkbook so she kept the master and gave him a "sub" ledger. She would "transfer" spending money to "his" account. It was all one account. You are not actually doing the transfers. You are just tracking them so you can make the child's account number 123456-sub and the parent's 123456 if you want to.

Actually you misunderstanding there. A mother have many bank Accounts and SubAccount in under her main account. She is give permission by Power of attorney to use subAccount to her child.
NOT husband checking wife account or Wife checking husband account. This is child and mother. Because every child and little members living between city for study.

Free Personal Finance Software. Download Includes Easy Checkbook Register (nchsoftware.com)

Take a look at this software and see if it makes sense to you.

it's not meet with my custom database.

Can you edit my sample copy... To see what you exactly want to do. Form I will manage it.
I would the required query result as
1) qryTotalCostByExpenseType
2) qryBankAccountBalanceByMembers
3) qryTotalExpenseByMembers
and table design (if better).

 

[smtazulislam]

In explanation about the family personal expense with Pat Hartman​

have anyone any others idea to complete this database ? I would like easily use it.

 

[smtazulislam]

Thank you very much. Its almost of my required. Appreciate for given times.
There are missing the tblExpenseDetails table. My opinion that relationship would like that picture.
But require your opinion ....

Why require Expensive Details?
Example :
My son Mobile Account, I will transfer 15000 BDT. This estimate money for his Admission fee, School Tutorial fee, Private Tutorial Teacher fee And School Hostel fee.
Here I want to each part of expense how much money he will be pay that record.
Please give me a advice about the Expense Details.

 

[smtazulislam]

Hello Sir, Thank you very much and I apologize for the late reply. I am busy with other work. I will try to add some data and then I will reply to you about what I face problems.
I know you are much times expense with me free advice. I appreciated.
And I hope you will be with me before completed my database.

 

[smtazulislam]

Each transfer have many cost list.
Example:
As per I am explain in the picture for one member NAIF Cost details.
How can I entry please be advice. And how I know the Balance of Naif.

 

[smtazulislam]

Hello sir Pat Hartman any suggest ....

 

[smtazulislam]

Sir, the Problems is INCOME person is ONE, He/ will send money to FATHER and SISTER account.
SISTER Or FATHER is divide the money to other members. Both inform me the amount where they transfer and how much.
Some members living out of the country for study.
Some members are out of home City for study.
so every money I do like that. But I need all data records and I want to know how much money balance in the member's account or Hand.
How to do that ?