query calculations based on page number

[mlrucci]

Good afternoon, I am attempting to create a query that will compute the total $ amount based on the number of pages that were printed. I am including pictures to simplify the understanding of what I am attempting to accomplish as my tables are more complex and will just add to the confusion. I think I am using the wrong expression in the wrong place or am missing something else?

My table consists of price, Tier Low and Tier High.




First query calculates the number of documents grouped by the number of pages printed.




Second query pricing matrix based on the number of pages printed and product type.




So far so good. My problem, When put them together and try and calculate based on the number of pages printed in the product type, it only choses the first row of pricing and is not accurate.




I have used the between expression:





Not sure what I am missing. Any insight would be useful. Thank you

[ranman256]

pages have no meaning to a query.
the report page CAN give you a sum / page.

[mlrucci]

See original post. Pictures didn't import

[mlrucci]

I think I was not clear. My apologies, I am not looking for the sum of the pages. I need the price to be based on the number of pages printed for that particular document. For example. If document 1 has 10 pages printed, the price for that document would be $3.25. If document 2 has 42 pages, the price for that documents would be $6.00. then need to multiply the total once the matrix is correct. The multiplication isn't the issues. It's choosing the correct price for that document.

[NoellaG]

I'm afraid we will need at least a simplified example of your data structure to be able to advise on a query syntax.