Consulta de Saldo de Caixa

[Orlandi]

Bom dia !
Este é um segundo post que faço. Talvez eu não tenha me expressado corretamente no primeiro. Vou tentar me expressar corretamente agora.


Tenho duas tabelas simples. Quero fazer uma consulta com os totais das duas tabelas. É possível ?
Se puderem ajudar, agraço.

[Welshgasman]

Non comprende. Lo siento.

[Orlandi]

Good Morning! I have two simple tables. I want to make a query with the totals of the two tables. It's possible?

[Gicu]

You need to explain in more details what exactly you want; you seem to have some sort of accounting log so what is the purpose of the totals query?

To get what you have in the second screenshot you can use domain aggregate functions such a dSum() on the original tables or dLookup on totals queries that are doing the summing first.

Here are a couple of examples for the Vendas table (notice that you need to enclose the table name in square brackets because you have spaces in their names):

Total_Valor:dSum("Valor","[1 Vendas - A Receber]")
Total_Saldo:dSum("Saldo","[1 Vendas - A Receber]")

You can use this calculated expressions in a query or in a form.

Cheers,