Deleting items without commas at end

[Guest]

First, I tried Not Like "*[,]" along with the rest of the instructions for
automatically deleting duplicate records from a table. I received the error
mesage --You Can't specify the criteria for the asterisk (*). Because the
asterisk represents all the fields inthe underlying table or query, you can't
specify criteria for it. Add the asterisk to the query design grid, along
witht he fields you want to set criteria for, and then enter criteria for the
specific fields. In the query design grid, clear the show checkbox for the
criteria fields, before you run the query.

What I did was change the first line to the field title. Dragging the
asterisk had put the asterisk and the table name in the first line. Then I
hit the Run key.

What this produced were the 13 emails without the commas in the new table.
How do I produce a table with all the emails minus the ones without commas?
I cannot just delete these emails because the error message comes up about
the index creating duplicates.

 

[[MVP] S.Clark]

Substitute the tablename.* for any one field name from the table.

 

[Guest]

What does your answer mean? is it the name of the table you are deleting
from or the new table, then .*?

Substitute the tablename.* for any one field name from the table.

--
Steve Clark, Access MVP
FMS, Inc.
www.fmsinc.com/consulting

First, I tried Not Like "*[,]" along with the rest of the instructions for
automatically deleting duplicate records from a table. I received the error
mesage --You Can't specify the criteria for the asterisk (*). Because the
asterisk represents all the fields inthe underlying table or query, you can't
specify criteria for it. Add the asterisk to the query design grid, along
witht he fields you want to set criteria for, and then enter criteria for the
specific fields. In the query design grid, clear the show checkbox for the
criteria fields, before you run the query.

What I did was change the first line to the field title. Dragging the
asterisk had put the asterisk and the table name in the first line. Then I
hit the Run key.

What this produced were the 13 emails without the commas in the new table.
How do I produce a table with all the emails minus the ones without commas?
I cannot just delete these emails because the error message comes up about
the index creating duplicates.