What is the statement for

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

if something is not = "Closed","Sent","Completed"?

I do not want to see these in my query when I run it.
 
if something is not = "Closed","Sent","Completed"?

I do not want to see these in my query when I run it.
Click to expand...

Use a criterion of

NOT IN("Closed", "Send", "Completed")

on the field containing these values.

John W. Vinson[MVP]
 
fredg,

I suck at expressions, thanks for the help.

I have one more question,

If I have a date i.e. 12/31/2006 and I want it to show if it is 21 days past
the date (as a number), how do I write the expression? I think it is:
Now()+[tblOnyxData]![Data Received Date], but I don't know what to put after
this to show a number?? Please help.
 
John,

Can you help with the last post I made? fredg, all help is appreciated
also. I just need to get the done quick, and I don't know where to go from
where I stopped in the expression
 
Can you help with the last post I made? fredg, all help is appreciated
also. I just need to get the done quick, and I don't know where to go from
where I stopped in the expression
Click to expand...

We don't know either, because you didn't post the expression.

John W. Vinson[MVP]
 
Back
Top