I always have problems with date functions.
This is my query:
select * from "99 - Report\Test" where name = 'Test' and year(DATA) =
Message: [Lotus][ODBC Lotus Notes]Name, constant, or expression
Message: [Lotus][ODBC Lotus Notes]Incorrect syntax near 'WHERE'
I tried with another view (without spaces, so without " "), same problem.
Problems with "printWhenExpression":
Do not work (do not print anything!). Where is the problem?
I made a sum of a field by group.
In the last page I would like to have the total sum. How I have to set the
C1 C2 C3 (C1-C2)
58 32 23!!! ????
110 64 46
Thank you very much