Generating Reports With Charts

[taporctv]

Hello, I'm new to this forum. Ok here's my problem. I have a query that returns a number. I am able to create a chart from this query. But I also have another query that returns a different number. I want to take the result of query 1 and divide it by query 2 and create the chart. I am completely lost and have no idea how to do it.

[mattj]

You will need to create third query that uses the first two and create a new column that performs the calculation. I assume that there is a field in both queries that you can create a join on so that the third query know which record in the fiirst query goes with what record in the second?

The column in the third query would be something like:

MyCalculatedField: [Query1]![Query1Fieldname]/[Query2]![Query2Fieldname]

HTH
Matt