generating a report from multiple queries

[DianneBeck]

I have developed a developed a database to keep up with appropriation amounts and expenditures. The expenditure table contains all expenditures for the entire year. I have developed queries for the appropriations, mtd expenditures and ytd expenditures. I need to develop a report that reflects the fund, program and account, appropriation amount, mtd expenditure, ytd expenditure.



Every time I try to generate the report from all three queries I get a message that tells me that I'm trying to generate a report from tables and queries but I'm not. I'm only using queries. I need to pull totals on the fund and program levels.

Thanks

[Micron]

[Every time I try to generate the report from all three queries]
What does this mean? You can only have one recordsource for a form or report AFAIK. Is this a report with two sub reports, hence 3 queries? If not, think you will either need one query that uses the other 3 as data sources or one table based on those 3.

[DianneBeck]

How do generate a table based on the three queries?

[Micron]

You put your 3 queries in the table part of the query design grid for a new query as you would for tables. Make the appropriate joins and add the fields you need to the field grid and either save your new query as a select, or if it makes more sense, as a make table. If the latter, I almost never keep a make table query once I'm happy with the design because I suspect the constant over-writing of it contributes to database bloat, but I have no proof of that. You also have to deal with the over-write prompt. So for me, the make table is changed to an append. You set the form or report record source to the new query (or table).