Recent content by sleepy11

Thanks for your reply. I will start to get familiar with the function part.

Thanks for the explanation. As per my understanding, it is for the door number. Since it is a question in the MS Access certificate book, which doesn't touch the function part, I don't have knowledge on it, so far. :(

Actually, it is a question in the MS Access certificate book. The data, which need to be updated, are in the columne "ProAdresse".

Thanks for the detail explication. But base on my current Access knowledge base, I would like focus on the "find/replace" dialog and persue the function a little bit later.:(

Keep it unchanged.

Thanks for the reply. I understood regex, but it seems that Access doesn't support it in the "find/replace" dialog, or only support some wildcards as per below page: Use wildcards in queries and parameters in Access Could you please provide an example for my specific question above?

I'm newbee to MS Access and just got a request to add the comma to the value of the address column, not just change the format of view. Before, the value is like "1234 johndon street", After, the value should like "1,234 johndon street". (with an extra comma after "1") And there are thousands...