Merge fields

[ACCESS NEWB]

How can I merge 4 fields from 1 table into new field which will look like:
field1,firld2,field3,field4
pls help

 

[David Eagar]

Use a query and create fieldx:=[field1]+[field2] etc etc

 

[ACCESS NEWB]

is there a way to separate fields in new field with ,

 

[David Eagar]

Yep, you need fieldx:=[field1]+","+[field2] etc etc