Copying data from fields to another

[jk42]

Hi!

I have a field that has a description of the project I'm working on, which has client information on it. I want to take all 600 of those records and copy them to fields in the same table, so that I can remove the client information, which will allow me to pull whichever of those two I need when I run a query. Is there a simple way to do this?

Thanks!

 

[David R]

I *think* what you're asking is to extract from a long Text/Memo field the actual data you want to store in your new fields. That is a good and noble thing, and you should investigate the Left(), Mid(), Right(), and InStr() functions to see how to do it. If you post sample data we might be able to write it for you, but learning how those work for yourself will be valuable.

However if that is not what you want, we need more information.

 

[jk42]

I think that's what I meant! If it were in excel, i would literally just be trying to copy and paste column A into column B, so I could change a few things but still be able to access the original column and the manipulated information. Is that what you were saying above? Sorry, I'm not super knowledgeable with Access lingo.

 

[David R]

Can you post some anonymized data? in other words what does your Memo content look like now, without breaking patient confidentiality, and then what do you want to put from that memo field into your 'other' new fields (and what are those fields called)? Don't worry about the lingo so much, we're pretty good at translating Newbiese here.