Calculate allocated budget based on 2 criterias

[Chatholo]

Hi there,



I have two tables:

Table 1: Product type | business type | Total budget $
Table 2: Product type | buisness type | Country A | X% of the Total budget

The result I want to get to is:
Product | business | country | Total budget in $ (for that specific business and this specific country)

Not sure how to calculate with two criterias, and if I shoud do it in the table or in a query ...
Thanks for your help!!
C.

[June7]

You can't do the calc in table because the raw data is in two tables. Must use query.

Just do a join linking on product and business fields.

[Chatholo]

Works perfectly! Thank you for the quick and very efficient post!