I'm beginning to suspect that the problems with both reports are due to null values in the fields.
For the phone issue, try this:
(
(not IsNull({TABLE1.PHONE1}) and {TABLE1.PHONE1} = {?Phone Number})
or
(not IsNull({TABLE1.PHONE2}) and {TABLE1.PHONE2} = {?Phone Number})
)
For your other report, try this filter:
{
TABLE1.DATE} in {?DATE START} to {?DATE END} and
((not IsNull({TABLE1.NAME}) and {TABLE1.NAME} startswith {?NAME}) or
(not IsNull({TABLE2.NAME}) and {TABLE2.NAME} startswith {?NAME}) )
-Dell
IP Logged
YOU ARE A GENIUS! 