Search results

  1. G

    Summing 2 values in a report

    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.
  2. G

    2 way sync with OUTLOOK

    Thanks I will take a look at this again.
  3. G

    Summing 2 values in a report

    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"
  4. G

    Summing 2 values in a report

    Buyer Query Buyer Agent co Buyer Agent Commission Street Name Listing Query Listing Agent Co Listing agent Commission Street Name
  5. G

    2 way sync with OUTLOOK

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

    Summing 2 values in a report

    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...
Back
Top Bottom