Selasa, 18 Agustus 2015

[MS_AccessPros] changing how data is stored

 

I have  a table that was created by an electronic health record company. for some reason they did not include the {  } symbols around the patient ID, as they have in other tables. I am unable to match up the patients due to these missing symbols.  How can I add it back into a table (or a query from that table where I convert the person ID to include the symbols?

thank you so much

Patty


example:

Person_ID  E8D2E-C4B1-45C6-BE84 on the table with error

and for the other tables with this information:

{E8D2E-C4B1-45C6-BE84}



__._,_.___

Posted by: pattykf@cox.net
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

.

__,_._,___

Tidak ada komentar:

Posting Komentar