Question about double in my query

[keawee]

Hello,

I have a problem with my query which name “Query One”. In the field “Call_Number”, I have most double and I want keep just one record. My problem is in two fields, “Block” and “Out Of Delay 1”. If I hide these fields, I can use GROUP BY but I would like see these fields.

In the query, I have 39 records and I want to reduce at 19 records If I delete the double.

Example:
The call number “SV0401270145@@1”, I have two lines and I want to keep just the line where the field name “Out Of Delay 1” is not empty

The call number “SV0402060107@@3”, I have two lines and I want to keep just one line.

The call number “SV0402140001@@1”, I have one line and I want to keep it.

The call number “SV0405060089@@1”, I have three lines and I want to keep just one but the field name “Out Of Delay 1” is empty in the three lines.

Could you help me about this problem.

Thank you

Keawee

 

[maxmangion]

I am not sure if i understood your question correctly, but from the Database Window, Choose Queries, click on New and Choose a Find Duplicates Query Wizard.

 

[Jon K]

In the Totals Query, you can use either First, Last, Min or Max for the [Block] and [Out Of Delay 1] fields, and use Group By for all the other fields.
.

 

[keawee]

Thanks for your answer maxmangion and jon k.

I 'am progressing about my problem but i have a last question and i can't resolve it alone.

In the field call number, i have this “SV0401270145@@1”. I have two lines and I want to extract only these two lines in a query but the field "Out Of Delay 1" is in the same time empty and full. How can i do to extract only these record from my table Access?.

Thanks for you answer

Keawee

 

[Jon K]

In the field call number, i have this "SV0401270145@@1". I have two lines and I want to extract only these two lines in a query ...

Query2 in the attached database will retrieve the two records with call number SV0401270145@@1.

In my English version of Access, I just put SV0401270145@@1 in the Criteria row for the Call_Number field and Access surrounded the number with double-quotes in the criteria when the query was saved, i.e. it became "SV0401270145@@1" in the criteria. Hope it works in your version of Access, too.
.