How can I divide up a field into several other fields in Access w.

[Andy Campbell]

I am using access to do data conversion and I need to split data in a field
into 3 separate fields. Do I use a query to do this?

 

[Duane Hookom]

Use an update query which allows you to update some fields with
information/calculations from other fields.

 

[Andy Campbell]

Thank You it worked !

Use an update query which allows you to update some fields with
information/calculations from other fields.