Search results

  1. 1

    Report or Query? Totalling columns in X-tab query

    Hi all I have a report based on a crosstab query whose code is: TRANSFORM Count(Q_Tasks_SATRs_OS.ID_Tasks) AS CountOfID_Tasks SELECT Q_Tasks_SATRs_OS.Tax, Count(Q_Tasks_SATRs_OS.ID_Tasks) AS [Total Of ID_Tasks] FROM Q_Tasks_SATRs_OS GROUP BY Q_Tasks_SATRs_OS.Tax PIVOT Q_Tasks_SATRs_OS.Partner...
  2. 1

    Report or Query? Totalling columns in X-tab query

    Hi all I have a report based on a crosstab query whose code is: TRANSFORM Count(Q_Tasks_SATRs_OS.ID_Tasks) AS CountOfID_Tasks SELECT Q_Tasks_SATRs_OS.Tax, Count(Q_Tasks_SATRs_OS.ID_Tasks) AS [Total Of ID_Tasks] FROM Q_Tasks_SATRs_OS GROUP BY Q_Tasks_SATRs_OS.Tax PIVOT Q_Tasks_SATRs_OS.Partner...
  3. 1

    Report or query? Totalling columns in Crosstab

    Hi all I have a report based on a crosstab query whose code is: TRANSFORM Count(Q_Tasks_SATRs_OS.ID_Tasks) AS CountOfID_Tasks SELECT Q_Tasks_SATRs_OS.Tax, Count(Q_Tasks_SATRs_OS.ID_Tasks) AS [Total Of ID_Tasks] FROM Q_Tasks_SATRs_OS GROUP BY Q_Tasks_SATRs_OS.Tax PIVOT Q_Tasks_SATRs_OS.Partner...
  4. 1

    IIF() evaluates incorrectly?

    I have been staring at this for hours. If anyone can see what I have done wrong I would be so grateful. In query Q_CTPayDeadline_1 Record ID_Tasks = 194 Field [Stage1B] SHOULD (I believe) evaluate to date 2010-01-01, not 2004-03-31, the former being greater than the latter. The criteria for...
Back
Top Bottom