How to make a row with totals in a query

[stef123]

I have to make a query using information out of an existing table. In the table there are two columns which I have to use in the query. I need to have the totals of these two columns. The table looks like this:
country amount1 amount2
A 2 3
B 4 6
C 5 2
D 5 3

What I want the query to look like is:
country amount1 amount2
A 2 3
B 4 6
C 5 2
D 5 3
16 14

As I am dutch, my english will not be perfect
Thank you in advance

 

[MStef]

Hello stef123!

Look at "DemoQrySumA2002.mdb", i think it can help you.
Open form "frmREADme".

 

[stef123]

Hi MStef,
Thanks for the quick respond, but I can't open the file because i'm using access 2000 and this is a MS access 2002 file, is there anyway you could convert it to 2000 for me?

thanks again

 

[lcross]

there you go

 

[stef123]

Wow you guys are great, is it also possible to do the same, but leave one of the country's away from my totals? For example, if I want to leave country A aside so that the result has to be:
country a1 a2
14 11

 

[MStef]

Hello stef123!

Here it is (without A) "DemoQrySumA2000"

 

[stef123]

Thanks again, that's exactly what i meant!