Excluding records

[victora]

I have a primary table that is link to a secondary table by a key field. I want to process all records on the primary but exclude the record if a field (not the link field)in the secondary table is equal to certain value.

If I have a filter to exclude records base on the field, it will process only records that has the same key. I want to include on my count, records on my primary even there is no match on the secondary file.

How do I do that? Any help is appreciated.

 

[chelseatech]

IsNull({table2.field}) or
{table2.field} = value

But it gets too complicated if you have other criteria in the report. If that is the case, use a view in the DB to get what you want. Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm