complicated formula for a report

[wizard454]

hi

i wondered if anyone could help me with a formula i am trying to construct.
i have a report which is based on a query where the user types in the ID of the project they want to view.

here is a screen shot of the report
http://i132.photobucket.com/albums/q19/lost989/formula.jpg

i wondered whether it was possible to have a calcualtion to show how much was spent on different categories.
so there would need to be a formula to calculate all those records named as timber thier indivdual cost times the quantity of each. i need this for each category of items.

is this possible?
any help is appreciated
thanks

 

[james_IT]

you may need to make a query that counts the amount of each product in the report. Then you just multiply the qty of each product bought by the price of each product to get the total from that product.

i have attached an example of the query

just make a list box or something based on the query in your report

hope this helps