What is the statement for

[Guest]

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

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

 

[fredg]

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

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

as query criteria:
Not In ("Closed","Sent","Completed")

 

[John Vinson]

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

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

Use a criterion of

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

on the field containing these values.

John W. Vinson[MVP]

 

[Guest]

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.

 

[Guest]

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

 

[John Vinson]

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

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

John W. Vinson[MVP]