Need making Customer Ledger

[RizwanMalik]

Hi.
i'm a new user of access and want to make a customer ledger with following details.

my requirments are :
Qty*Per KG Rate

and total is shown in Debit

when add payments in Credit then it shows Balance.

looks like in excel

Inoive Number​	Invoice Date​	Customer Name​	Product​	Qty​	Rate Per KG​	Debit​	Credit​	Balance​
20-Dec-22​	1​	ABC​	Fresh Milk​	1​	120​	120​		120​
20-Dec-22​	2​	ABC​	Fresh Milk​	2​	120​	240​		360​
21-Dec-22​	3​	ABC​	Payment​			0​	500​	-140​

in excel sheet same as Qty*Rate Per KG

and Balance is Balance+Credit-Debit


so i need in access create customer ledger .any one help please.

 

[June7]

Balance should not be saved into table, it should be calculated when needed. Build a report and set textbox RunningSum property to Yes. Expression in ControlSource like: =Nz([Debit],0)-Nz([Credit],0)

Strongly advise not to use spaces in naming convention.

Have you studied an introductory book on Access database? Should not save customer name and product name in this table. Should have Customers and Products tables and save CustomerID and ProductID.

 

[RizwanMalik]

Balance should not be saved into table, it should be calculated when needed. Build a report and set textbox RunningSum property to Yes. Expression in ControlSource like: =Nz([Debit],0)-Nz([Credit],0)

Strongly advise not to use spaces in naming convention.

Have you studied an introductory book on Access database? Should not save customer name and product name in this table. Should have Customers and Products tables and save CustomerID and ProductID.

Thank You it's works.