On Sun, 3 Oct 2004 17:11:07 -0700, "faxylady"
wrote:

I have an interest in this particular topic also. M question is how to find
items that are missing a comma at the end when all other items in the field
have commas at the end.

A criterion of

NOT LIKE "*[,]"

should do the trick.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps