I'm working on an inventory list that seems to have duplicate values in the SNs because a dash (-) was entered in the string on some records, not on others. What function do I use to remove the dash in a query to view duplicates? Most records in question are in the format of 00-0000, but some are longer, 0000-00000. Thanks for any help provided!!

Follow the link. It should be just what you want. http://support.microsoft.com/support/kb/articles/Q138/7/74.asp?