How to calculate by sim - in access

[AliMohamed]

Welcome,
This is my first post on the forum, and I hope you can help me create my first database on Access
The database that I work on is entering data, compiling and calculating the costs of each product
What I want is to compute by minus from 2 queries in 1 query to add the computed in the reports.


This is the first problem I encountered in creating the database. I wish you success in what is to come and I hope you will be happy to help me

[June7]

Happy to help if I had adequate info to work with. I really don't understand what you want to accomplish. Provide sample data and desired output. Build tables in your post or a mockup in Excel and attach file, even provide your Access db.

[AliMohamed]

Happy to help if I had adequate info to work with. I really don't understand what you want to accomplish. Provide sample data and desired output. Build tables in your post or a mockup in Excel and attach file, even provide your Access db.

Agent	Price	Paid	Total after paid
Ali	1000	200	800
June7	5000	10000	-5000

[June7]

What you show would be result of simple arithmetic.

[price] - [paid]

I still don't understand what difficulty you are having.

What 2 queries are you working with? What data do they produce? Why can't you accomplish what you want? What have you tried?

Again, suggest you provide data. Easiest may be to just provide database.