Hello
I am creating a bd to manage a my shop. I have a [revenue table] and [expenses table]. I would like to create a query to calculate the [Total Revenue] - [total expenditure]
Enclosed my bd
Thank you kindly help me
Hello
I am creating a bd to manage a my shop. I have a [revenue table] and [expenses table]. I would like to create a query to calculate the [Total Revenue] - [total expenditure]
Enclosed my bd
Thank you kindly help me
Your db is not attached. I would probably have revenue and expenses in the same table, and use a totals query to get the totals.
Hello
Yes I try to attached the db but there is a problem. Your solution is ok, but in my case revenue and expenses are in different tables
thank you
As paul suggests, much easier if in one table. If not then create two separate queries to total each table then a third to subtract one query from the other
ok thank you.