Percentage Costs

[mlyles]

I have 6 records, with each of them having individual costs for either Germany or United States. On the bottom I have the overall totals, Germany totals, and US totals, with Germany at 42 percent of the overall total and the US at 58 percent. Is there anyway I can play around with the percentage and it changes the totals of each. For example lets say I wanted Germany at 30 percent and the US at 70 percent, I would enter in the percentage and Access would do some calculations to the records to make them the correct amount. Some of the cost I have on each record are Material Costs, Travel Costs, Other Costs, etc. and certain cost can't exceed certain numbers.
Thanks

 

[trucktime]

Percentage

How would you determine which type of cost in which record to change in order to make it work?

Trucktime

 

[mlyles]

This is kind of what I wanted to know. Since there are certain amounts some costs can not exceed for example travel costs can not be > 500, so it would put travel costs at the needed price not exceeding 500 and the rest at the prices needed to obtain the correct percentage. Any ideas.
Thanks