NULL Value Problems

[wil1952]

I am having a problem getting detail line info to show when one field is null. I am creating a report using fields from multiple tables. The main table is a visits table and another one is a visits mileage table. The second table holds the mileage that the person did when they made a visit to a home. I am select multiple fields from the visit table and everything looks great, but when I add the mileage field from the visits mileage table it only gives me a detail line if the individual put mileage in. If they left in empty it does not show any info for the visit. I have tried using a selection formula that states if mileage is null or is > 1000. But Still get the same info. Any help would be appreciated. Thanks in advance.

 

[Turkbear]

Hi,
Link the tables ( Visits -> Visits_Milage) using a left outer join..





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[wil1952]

It worked, thanks!!!!!!!!!!!!!!!