crosstab problem

[aneats]

I'm sure this seems very simple to some, however i am finding it difficult to obtain the results that i want.
I am trying to create a crosstab query to display the following...

2 columns, C1 and C2.
4 rows, R1, R2, R3, and R4.

Values displayed in these fields are derived from 2 queries.
Query 1 produces 2 sets of results.. 'Town' of which there are 2 possible results (Town 1 and Town 2), and 'Total Grant' .
Query 2 Produces 1 set of results.. 'Grand total' which is the sum of 'total' from the previous query. I then joined these 2 queries to try and create a crosstab...

the crosstab query should produce the following results in the following fileds..

C1, R1, Blank
C1, R2, 'Town 1'
C1, R3, 'Town 2'
C1, R4, 'Grand total' (heading)

C2, R1, 'Total Grant' (heading)
C2, R2, Total Grant for Town 1 (value)
C2, R3, Total Grant for Town 2 (value)
C2, R4, Grand Total (Value)

After all my efforts, i can only come close to achieving this.
can anyone help. please.

 

[Rich]

What results do you get?

 

[aneats]

I get 3 rows, and 3 columns.

C1, R1 = 'Grand total'(heading)
C1, R2 = Total 'Town 1' (value)
C1, R3 = Total 'Town 2' (value)

C2, R1 = 'Town 1' (heading)
C2, R2 = total 'Town 1' (value)
C2, R2 = BLANK

C3, R1 = 'Town 2' (heading)
C3, R2 = BLANK
C3, R2 = total 'Town 2' (value)

 

[aneats]

To remedy this problem, i had to put the details into a report, which gave me the desired results. The crosstab query doesn't seem to be able to deal with this one.
thanks anyway.