If expressions

[Guest]

In my query I have an Alert Date and a Set Fraud Date field. I want to
display any record that has a date (in either field) that is greater than
11/01/05. The expressions that I have built keep pulling some of the records
twice. In those situations the date in both fields were both greater than
11/01/05.

How do I create an expression or criteria that will look at both fields and
pull the record only once if either date is greater than 11/01/05?

 

[Guest]

Use 'OR' in your select statement.

Here would be an example:

If "field 1" is > 11/1/05 OR If "field 2" >11/1/05 ...

 

[Guest]

When I tried that it told me that Is operator only in expressions with Null
or Not Null. Unless I am typing it in wrong?

 

[Guest]

Can you post your SQL?

 

[Rob Oldfield]

In the QBE grid, put >11/1/5 below Alert Date and then, on the row below
that one, enter >11/1/5 below Set Fraud Date. Two separate rows is an
'or'... either one or the other can be true.

 

[fredg]

When I tried that it told me that Is operator only in expressions with Null
or Not Null. Unless I am typing it in wrong?

The word IS is not correct in this expression.
Also, hard coded dates must be surrounded with # symbols.
As SQL criteria use:

Where TableName.[Field 1] > #11/1/2005# OR TableName.[Field 2]