Adding query records

[kicken18]

Hi, i have a query that retrives from the DB the clients monthly cost (i.e what they pay us) which return say 10 records. Now i want to add together the data returned from all of the records to give a Total income.

Thanks
Chris

 

[llkhoutx]

Query the query (and sum) which gives the individual costs.

 

[kicken18]

ok that all sounds good, but i dont know how to do that lol. can you explain please

 

[llkhoutx]

Attached is a simple sample 2k mdb illustrating; a table and two queries..

 

[kicken18]

ok yes that does work, but not in my example. See here you used client ID and added all the records for client ID, which words with mine, but i have 1 server per client, so i want to add the cost for each client, so client 1,2,3,4,5 are displayed with cost next to it, i want a total cost of all of those results added up and a final total of them all so i would have 1 total for all clients, and so 1 number

 

[llkhoutx]

So query the query that queries the query, or simply query and sum the table without the ClientID grouping.

 

[kicken18]

lol as i said, i dont know very much about Access queries so how can i query a query. Do you mean set up a query that gives me the results, and then have a query that runs using the data from that query?

 

[llkhoutx]

Yes, that's one way. Another is to query the underlying table. Look closely at the queries in the mdb I posted.