Ms Access: What is the best way to extract Appropriation as per distribution (1 Viewer)

[Kamayo Ako]

What is the best way to extract appropriation as per percentage distribution.
1. Distribution Percentage can be changeable
2. Particulars/Services can be change or have an additional
- example i need to add Represenstation Expenses 5%
3. Maximum 100% Total Percentage Distribution

AppropriationTable		Total Amount
GENERAL APPROPRIATION		43,000,000​
Query
PARTICULARS	Distribution in %	Amount
PERSONAL SERVICES	35%	15,050,000.00
MOOE	30%	12,900,000.00
SANGGUNIANG KABATAAN	10%	4,300,000.00
CALAMITY FUND	5%	2,150,000.00
DEVELOPMENT FUND	20%	8,600,000.00
TOTAL	100%	43,000,000.00

Thank you so much for continuing support.

 

[theDBguy]

Try DLookup()?

 

[Kamayo Ako]

Try DLookup()?

thank you sir for the response.

 

[theDBguy]

thank you sir for the response.

Hope it helps...