I am locked in something simple:
With this expression:
SELECT (Repairs [Rep Id],[Withdrawn Date]>DATETIME ([Last payment]. [Date]))
- If I test the expression with the “Test” button, it correctly returns all Rep Id’s.
- In the Form view where I want to show it, you don’t see anything.
- If I replace the expression DATETIME ([Last payment]. [Date]) with a written date, it shows the list perfectly.
- [Last payment] is a virtual column with the following expression
MAXROW (“Payments”, “_ RowNumber”), of type Ref, which correctly returns the date of the last payment.
What am I doing wrong?
Additionally, I make another query, how do I locate the inline view of a SELECT expression to modify which columns are displayed?