hello everyone !
i have a double click event where it opens up for me a master list.
i tried this one
and this one
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 !
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 !