This content has been marked as final. Show 2 replies
You have several problems here...
- You need to quote the table label inside the Peek(): Peek('F1', 1, 'Temp')
- If you want the date of the first record, you should use 0 instead: Peek('F1', 0, 'Temp')
- If you want the variable 'test' to be displayed as a numeric, you should wrap the expression in Num(...): Num(Date#(...))
- The dollar expansion $(test) might expand the variable using decimal comma, which will cause an error. The simplest solution is to quote the dollar expansion: 1 + '$(test)' as Test