Recent content by Goldie9

SELECT Sum(SumTotal) AS SumGrandTotal FROM (SELECT Sum(Commission) AS SumTotal FROM Buyer Sales Comparison UNION SELECT Sum(Commission) AS SumTotal FROM Listing Sales Comparison) AS tblCommissions; I created a new table ALL SALES and appended the 2 queries into that table and seems to work.

Thanks I will take a look at this again.

I am getting several Syntax errors. Actually query names are Buyer Sales Comparison and Listing Sales Comparison. Do I need to create a table Commissions or will the Union create it when I run it. (First time using "UNION"

Buyer Query Buyer Agent co Buyer Agent Commission Street Name Listing Query Listing Agent Co Listing agent Commission Street Name

My database has a TASK table. I would like the tasks not completed to be synced to my OUTLOOK tasks? Is this possible?

I am running a real estate report that has 2 seperate queries. The commission calculated when I am the Listing agent and another when I am the Buyers agent. I can run the queries to get the sums for each query but would liek to run a query that totals the sum for both. OR in a report allows me...