Query help

king07

Registered User.
Local time
Today, 08:57
Joined
Jan 8, 2007
Messages
24
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.
 
Moniker said:
SELECT * Your_Table_Name WHERE Status = 'Overdue';

when i enter that i am getting an invalid error--
"you have entered an operand without an operator"

any suggestions?
 

Users who are viewing this thread

Back
Top Bottom