This is probably pretty easy but I need help with a selection formula. I want to first select customers by their contract date from one table and then include transactions from another table, based on a date range, if any. If there are no transactions just display customer info. The formula below will return the result I am looking for only if it finds data in the (trxhistoryhdr) table. Thanks


{Site.EndDate} in DateTime (2010, 01, 01, 00, 00, 00) to DateTime (2010, 01, 31, 00, 00, 00) and
{Site.ContractType} in ["KNBT", "LA1", "LA12", "LA2", "LA3", "LA4", "PM1", "PM12", "PM2", "PM3", "PM4"] and
{TrxHistoryHdr.TrxDate} in DateTime (2009, 01, 01, 00, 00, 00) to DateTime (2009, 12, 31, 00, 00, 00) and
{TrxHistoryHdr.PostedFromAppl} = "SB" and
{TrxHistoryHdr.CallType} > "0" and
{TrxHistoryHdr.TrxType} = 0