Search results for query: *

I have done that. I want 00/000000000 to read 00/000-00-0000 and using the special or custom did not change them.

I am trying to add the dashes to the Social Security Number for an entire column(over 12000 lines). I have selected Format - Cells - Special and Custom then OK and the colum does not change. Is there a formula I should use to perform this function?

Maybe I am not putting this right. I have tables made already. I am selecting the table and querying on certain parts and trying to make another table. I have tried to take one field and make the query and that does not work either. Once I get the Invalid Arguement I can not save any queries...

SELECT dbo_Temp_LatestLabtestDatesforAll.MRN, dbo_Temp_LatestLabtestDatesforAll.LabTest, dbo_Temp_LatestLabtestDatesforAll.LatestLabDate FROM dbo_Temp_LatestLabtestDatesforAll; Thanks for the help...

I am an intermediate user of ACCESS and still not sure what you mean by writing the code. I am taking data from 2 joined tables to make another table. Now that I get the invalid argument I can only run the query, I can't save it nor can I make it a table.

When trying to create a Make Table query I am getting an "Invalid Argument" error message. After that I can not save any queries nor can I do any make table queries. The queries I am doing are using valid fields and tables. It will run as a query, however will not make a table nor...