Search results

  1. T

    Multiple SUM(Column) on different table at the same time

    I want to SUM(COLUMN) on different columns of different table at the same time- in a single query in MsAcces.And there is a single condition which every table should meet.I tried the following way- But it is not generating the accurate result.Is there any problem? PLS help.
  2. T

    SQL Group by problem

    Why cant I execute the following query in MsAccess- SELECT SalesInvoice.ID, SalesInvoice.CustomerID, SalesInvoice.Commission, Sum(SalesInvoice.TotalAmount) AS SumOfTotalAmount FROM SalesInvoice GROUP BY SalesInvoice.CustomerID; It says " you tried to execute a query that doesn't include the...
  3. T

    MS Acces Query Help needed

    Can anybody tell me whats wrong with my MsAcces SQL given below.The error says- Syntax error[missing operator] in where clause SELECT SalesInvoice.`SalesDate` AS SalesInvoice_SalesDate, SalesInvoice.`ID` AS SalesInvoice_ID, UniteSalse.`ID` AS UniteSalse_ID, Unit.`Garage` AS...
Back
Top Bottom