Adding a product to a report

[abarin]

I have two tables one with percentages and one with salaries. I want a box in my report to have the product of the percent and the salary to show me a total.. What is the best way to do this? An SQL join statement? How do I put an empty box with the SQL behind it? I usually drag and drop. Sorry for the newbie question.
Thanks!

[alansidman]

Create a query and in a new field do the calculation. Make this query the record source for your report.

Alan

[abarin]

Thanks Alan!