excel - Pivot like query access -

i having huge database of records , i'm finding nightmare getting analyse data.

objective:

group data country of purchase (rows), years/months (rows), product (columns) sum of paid amount being value.

let me explain:

below sample excerpt table.

mytable http://i57.tinypic.com/2ijhi83.png

and here result looking able achieve using excel pivot table:

mypivot http://i60.tinypic.com/flvvjo.png

why use ms access: table has on 3 million records stored across many workbooks, , excel has limit of 1m in each sheet. excel crashes more not when loading >500k of data.

i installed older version of ms access (2010) has pivot tables option slow , did not allow me group correctly. tried using combination of queries , reports arrive result no avail.

any welcome :)

how doing aggregation in access , pivot in excel?

select country, year, month, product, sum(paid) mytable group country, year, month, product 

(year , month based on access functions date manipulation... alternatively, use date keep date functionality in pivot - make first of relevant month)

then use source of pivot table. pivot table formatting - can enough