Calculation with a Lookup field in another table

[bubai]

Hello folks. Here I come again with another problem in my database. So…


My Sales! table has fields [ItemType] and [Price] and VAT! table has [ItemType] and [VATRate]. Both tables has a common field which is [ItemType]. I’m trying to make a query which will calculate the VAT figure by multiplying the Sales table [Price] with the corresponding [VATRate] in the VAT table by matching the [ItemType] in both tables. I tried DLookup but couldn’t find a solution. How do I accomplish this?

[bubai]

Sorry guys,
I've fiund out the solution by myself. I just had to bring the two tables to the query grid and join the matching fields. Then simple multiplication had it done.