select distinct

M

Mario Krsnic

Hello everybody,
I have duplicates in the table. I would like to select unique rs, but to be
able to edit it. If I use select distinct then I cannot edit rs. How could I
get unique but editable rs? Maybe some reference to my ID-field-number?
Thank you in advance!
Mario
 
A

Arvin Meyer

Stop and think what you are asking. You want 2 records to show as 1 but you
want to edit only 1 of them. That is not possible. Which one would you be
editing?

I suggest running the duplicates query wizard and cleaning out the duplicate
records.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
M

Mario Krsnic

No, I don't want both of them to show. I want to see only one of them and to
change it. This is one possible
solution:
SELECT * FROM Tabelle WHERE DCount("ID","Tabelle","[ID]=" & ID)>1;
Unfortunately I need something for JET and Dcount doesn't work in JET-SQL.
 
A

Arvin Meyer

How will the query determine which one to show? How does Access know which
of the 2 that you'd like to edit? You can only edit 1 record directly in a
query or view although you can update all of them with a separate update
query.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

Mario Krsnic said:
No, I don't want both of them to show. I want to see only one of them and to
change it. This is one possible
solution:
SELECT * FROM Tabelle WHERE DCount("ID","Tabelle","[ID]=" & ID)>1;
Unfortunately I need something for JET and Dcount doesn't work in JET-SQL.

Arvin Meyer said:
Stop and think what you are asking. You want 2 records to show as 1 but you
want to edit only 1 of them. That is not possible. Which one would you be
editing?
Click to expand...
Click to expand...
 
Top