Recent content by Shyamdharam2

In Excel it can be Easy but in Access its not that easy Multple Condition Balancing... if Possible then try it

pdate Branch Bnos customerid place agentname grossamt taxes disc finalamt 01-Apr-24 India 1 24 New Delhi Abc 1542 77 5 1614 05-Apr-24 India 2 36 Bihar Xyz 2151 87 15 2223 06-Apr-24 India 3 54 UP Xyz 2514 103 25 2592 20-Apr-24 India 4 26 New Delhi Abc 1864 79 6 1937 24-Apr-24 Bangladesh...

Can Pls Give Me Little Help in Above Query To Find Branch Wise Oustanding Report Sample Data Below

Do you have Anything sample data for understanding, the structures

I Want Basic Query for Now.... I want only Ledger Balance of my Record Which I am Maintaing.... I Want A Query to Show me A particular Ledger Balance Still Date Report I Will Input , Let Suppose Mr. A In Opening Table I will Be Input X Amt Let Say 1000 In Bank Table Let one Day 50 Credit...

yes

Send me Your opinion and data structure to give my desires result

it Slightly Different Because it's totalling of Nameid and its has opening table + bank table (2) debit & credit column

I have two table in my db, 1. Opening table type id - autonumber date - date Ownerid- number Nameid - number debit - number credit - number Description - text 2. Bank table type id - autonumber bank - text date - date ownerid - number debit - number credit - number nameid- number narration -...

thanks for your help

Thanks for your Help, it works can you give me some tips for (late payment interest calculation) query or to track some kinds of remainder for late payment query..

Can you Just make the query in my sample database I am Unable to make it will be where kind of you..

Multiple Payment is there for single bill Sample Copy is there pls check it

Yes i Have Customer Name id in Bill Filed ----------------------------- in Bill Table Filed / Types Id : Autonumber PDate : Date Filed BNos: Number Customerid : Number Place : Text Filed Agentname : Text Filed Gross Amt : Number Taxes : Number Disc : Number Final Amt : Number...