I only want to show an Action if a criteria is met from another table.
The two tables are:
“qryAppsheetData” contains [JobID]
“WorkshopComplete” contains [JobID] and [Complete]
qryAppsheetData should only show an Action for the row if [JobID] matches both tables and Column [Complete] = “N”
I hate expression syntax, can anyone provide a quick solution?
Cheers
Acheived by adding a virtual column and creating a ref to the 2nd table. Then a Valid_If of:
ISBLANK([WorkshopComplete])
It doe sthe trick.
User | Count |
---|---|
42 | |
30 | |
25 | |
23 | |
13 |