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?

    Many thanks. And my apologies for posting in the "Reports" subforum when I meant to post in the "Queries" subforum. Just noticed. PS. It also seems to be recommended that if you use the Nz() function on a date field then better to use Datevalue(Nz()) else you risk getting a date that is...
  5. 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