Search results

Thanks will try

I may not have explained it well. I do not want to chege the data in my table. I built the query to fill a report. The person wanting the report does not want the dashes in the report. Thanks for the quick responses and any help you cann give on this

In my table I use the SSN format. In my query I want the SSN without the dashes. Could someone help with this. I have thought about using Left, Mid, Right, string function but can't find proper usage of these in queries. Any help would be appreciated.

Hi everyone! I am in the USA have done some Database work in the past. New to Access. Have some questions. Hope I can get some help. Glad to have found this sight. aglabrat