Merging two fields into one

[matpj]

Hi,

in addition to my post earlier I need to set one field up using data from two others (hyphen seperated)

e.g.

field1 field2 derived_field
UKE0323 Project3 UKE0323 - Project3

how is this possible?

 

[cghoga]

In a query:

SELECT YourTable.field1, YourTable.field2, [Field1] & " - " & [field2] AS Derived_Field
FROM YourTable;

On a form set an unbound text box's control source to:

[Field1] & " - " & [field2]

Hope this helps.