Divide by last two months depending on report date

[instereo911 via AccessMonster.com]

Good morning,

I have two queries set up... one a monthly query and one a weekly query. The
monthly query has two fields in it (Monthly_ReportDate and
Average_DailyReceipts). The second query is a weekly query that has two
fields in it (Weekly_ReportDate and Inventory).

I want to tie these two queries into one to say something like this

Take the Inventory of each Weekly_ReportDate and divide it by the sum of the
past two Monthly_ReportDate's Average Daily Receipts....

So here is an example

Monthly Query
Date Average_DailyReceipts
01/31/2008 523
02/29/2008 333
03/31/2008 456
04/30/2008 789


Weekly Query
Date Inventory
04/08/2008 1256
05/29/2008 6548


So the final result would want to look something like this

Date Inventory of Weekly Query / Sum of Average Daily
Receipts for Past two months
04/08/2008 1.59
05/29/2008 5.25


Any help? Any way of doing this.

Thanks again guys/girls!