Blank or Null Fields

[wf]

I have two fields in a table: Field1 Field2

My record has data only on Field2: 27

I've a query that says:
{table.Field1} = '27' or {table.Field2} = '27'

This doesn't bring me anything. But if I change the order of the query, that is asking for Field2 first, then it brings me the record.

What can I do?

PD: There are other cases in which I have data on Field1 and not on Field2 and it does the same thing.

Thanks

 

[kenhamady]

Try:

(if IsNull({Table1.A})
then {Table1.B} = '27'
else {Table1.A} = '27' or {Table1.B} = '27' ) Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)