Query to sum results of two crosstab queries

[Gryphoune]

I have two crosstab queries that pull quarterly sums; one for revenue recovered and one for revenue lost. what I would like to do is, if possible is to have a query that can subtract the lost revenue from the recovered revenue and give the balance on a quarterly basis. I have inserted screens of the two queries and a sample of the resulting reports generated.

[June7]

Does each crosstab have the same Property IDs? If they do, build another query that joins the two on that common field. If not, join them to table that does have all the property IDs.

[Gryphoune]

Well this would probably have been the solution but now things have changed slightly in that we are no longer grouping the properties so the Property Groupd Table is history. So now I need to build a query that gives me a quarterly summary of the recovered minus the loss xtabs.

I'm just getting back into Access after not using it for almost 10 years so my skills are a bit rusty and have inheirited this database which was built by a self taught. So the structure may a bit off but it is currently working sufficiently with some tweaking and changing needs.

[June7]

And the issue is... How to group records by quarter?

Create a field in query that calculates the quarter and use that for grouping criteria. Will probably also need the year for grouping and/or filtering.

Yr: Year([datefield])

Qtr: DatePart("q",[datefield])

or

YrQtr: Year([datefield) & DatePart("q",[datefield])