Combining three fields into one??

[matterhorn]

Hello all,
Having a little trouble finding out how to merge three separate fields into one after excecuting a query..

ie..
Fieild 1: .01uF
Field 2: 16VDC
Field 3: 10%

:::run query:::

Field 1: .01uF 16VDC 10%

Any ideas/suggestions??

Thanks

 

[rvvanderheijden]

Use an update query updating field1 with the three fields
by [Field1]&[Field2]&[Field3]
Hope this helps,
Bob