calculating fields

[goldwhispers]

how do i do a calculation based on a query

i want to calculate the total amount of books and multiply it by the price in the books table

i have the fields quantity and selling price, how do i do a query that calculates from there?

 

[SuicidED]

Put an ubound text box on your report and have as its control source =quantity*selling price