Hi
I have a quick question about queries--
I currently have a query setup to show the status of users career reviews- (completed,overdue and upcoming)- i want my query to just show the overdues in the status field, rather than all users (currently includes the other users who arent overdue but leaves them blank) how do i make it so only the users that are overdue show up??
here is the formula i am currently using for my status field
Status: IIf([Next Discussion Due]<Date(),'OverDue')
any help would be appreciated.
I have a quick question about queries--
I currently have a query setup to show the status of users career reviews- (completed,overdue and upcoming)- i want my query to just show the overdues in the status field, rather than all users (currently includes the other users who arent overdue but leaves them blank) how do i make it so only the users that are overdue show up??
here is the formula i am currently using for my status field
Status: IIf([Next Discussion Due]<Date(),'OverDue')
any help would be appreciated.