If expressions

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

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?
 
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 ...
 
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?
 
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.
 
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?
Click to expand...

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]
 
Back
Top