eliminating duplicate records when there is one null and one value

[srinivas.inbox83]

Hi all

Code   title  ExecName  date
A          1       NULL        02/28/2014
A          1       Sri            02/28/2014
B          2       NULL        01/28/2014
C          3       Phani          02/01/2014
D          4       XYZ          02/05/2014
E          5        NULL       02/09/2014
F          6         Raj         02/15/2014
F          6         NULL      02/15/2014

I want to eliminate NULL values only when the records or duplicated , like for A and F   I want to show non null values only (display only one record), and keep NULL values when there is no duplication like for B and E records though Exec Name is NULL still it has to show in the report .

I can not put Exec Name is not NULL , if so other records B and E will be eliminated

Please help me out how to resolve this

Thanks ...

[Raghuvir]

Hi Srinivas,

Why do u want to display NULL vales ?

Regards

[Raghuvir]

How about just displaying the executive names which are present in the "ExecName" query itme ?

Let us know about your thoughts on this.

Regards

[srinivas.inbox83]

The Exec Name is NULL but not the entire record is NULL (insted NULL say it as  blank ,  assuming the employee name is not loaded ) ryt , so if I keep the filter as Exec Name is NULL then the duplicate record will be eliminated but along with the other records for which Exec Name is NULL/Blank (which is a single record in my ex. code B and E) will also be eliminated ryt ? which should not be

Regards
Srini

[Lynn]

You could try setting the aggregate function for ExecName to maximum. If your query is set to auto group and summarize and all other values are duplicated it should give you what you want.