Need to see groups with no records only

[Fadius]

I am writing a report and need it to show only those groups that have no records.

I am looking for site names in my database that have no address records attached to them. I can get it to show those groups with any number o faddresses attached by using Selection Formula Group and selecting distinct count of any number except 0. I know I have Sites wiht no addresses, but cannot get it to display them.

Any help would be appreciated.

 

[Turkbear]

Hi,
Group on site name...
Use record Selection formula that selects only records where the address is NULL or blank .

If linking tables Site --> Address then use a Left Outer Join to link by site name and use the same record selection.
(NULL or Blank)





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