Can I merge 2 txt fields to 1 memo field

[cozzykim]

Hi,

I have an old database for generating service reports which has:
Report No
Date
Customer
Site

In separate fields which is fine

but also

wrk1
wrk2
wrk3
etc.

with a separate field for each printed line on the page
I would like to merge all these into one memo field while retaining the previous data which goes back 15 years (it came from a MSWorks 2.0 DOS db which is the reason for the weird structure I think)

Is there any way to write a macro or code to selectively merge some but not all fields in a table?

I've already copied the db and modified it after clearing all the old data, it works fine but I'd like to have access to the old data in the new format

TIA

Kim

 

[KeithG]

You can use an update query to merge the fields in the Update To field in the query reference the fields with a + or & between them.

 

[cozzykim]

Thanks, I'll try that

Kim

 

[cozzykim]

Thanks Keith, got it (eventually)