Solved Where condition in dbl click event (1 Viewer)

TipsyWolf

Member
Local time
Today, 06:30
Joined
Mar 20, 2024
Messages
249
hello everyone !
i have a double click event where it opens up for me a master list.
i tried this one
Code:
="RiskID In(SELECT RiskID FROM QddallA WHERE Site='site1' and duedate<date() and isactive=false and status='In progress' or 'New' and duedate<date() and isactive=false)"

and this one
Code:
="RiskID In(SELECT RiskID FROM QddallA WHERE Site='site1' and duedate<date() and isactive=false and status='In progress' or 'New')"

and it opens up a big list .

what i need is it should open up for me all records according this criteria
1. overdue, cause i have duedate<date()
2. from site1, cause it goes without saying as well as isactive=false
3. but here the problem - i need both 'NEW' and 'In Progress' status. I can make either of one status, but can't fugure it out how to tell access to pull data according this criteria with both statuses

your help much appriciated !
 
You would at least need

Code:
status='In progress' or status = 'New')
I would surround the conditions with () for the logic.
 
You would at least need

Code:
status='In progress' or status = 'New')
I would surround the conditions with () for the logic.
it worked !
awesome ! thank u , Sir ! :)
much appriciated for your help !
 

Users who are viewing this thread

Back
Top Bottom