adding totals from tables together

[redandblack]

i need to get a query running that allows me to add up the contents of two tables, then have the total of a seperate table subtracted from the first total (the two tables).


for example:


Donations + Funds - expensis

 

[Exodus]

Can you post it?

 

[redandblack]

the whole database??

 

[Exodus]

yes. How big is it.

 

[Exodus]

Try creating a group query for each table using the sum.

Create a forth qery having a three in it and do the math using expressions

 

[redandblack]

it wont let me put the database on here and i have no zip software. would u like me to explain in more detail whats going on in my database?

 

[redandblack]

so i should make four new querys, the first three based on my tables and the forth containing the actual equation? is this right?

also what will i need to put in where in each of these new querys?

 

[Exodus]

try my suggestion first.

Also you down load winzip for free.

 

[redandblack]

oh man, i thought that was ur suggestion..


could u try and explain it again for me, i struggle at producing databases

 

[redandblack]

oh christ i forgot to mention something

i need to add up (and subtract) specific fields in these tables

 

[Exodus]

see this attachment

It should ge you in the right direction

 

[Haymarket]

Thanks for the example - helped me.

I was having problems trying to get a report to total and order.

Basically I had a sports event where competitors entered events and so they would have up to 5 events they had entered and wtotalling there score in the report was easy, just a text box with a =(sum [points]) however I could not get it to put them in order. The reason being you can't! Now with the help of queries I can.

Thanks