Join tw Fields

[twosides]

My problem is simple.
I want to join field1 and field2 and store the result in field3.
The fields are text fields and I would also not want to perform the action every time the query or form or whatever opens as this could slow things possibly in the future.
It would be fine to do the join process on a new record just as it was exited for instance.
Many Thanx

 

[boblarson]

Since field one and field two are already there, don't store the concatenated field as you can bring them together using concatenation at anytime in a query, form, or report.

 

[twosides]

Hi Bob,
Yes I am actually bringing them together on a form but I want to sort the field with this code:

Private Sub lblDescription_Click()
If Me.OrderBy = "[chrDescription]" Then
Me.OrderBy = "[chrDescription] DESC"
Else
Me.OrderBy = "[chrDescription]"
Me.OrderByOn = True
End If
End Sub


But it throws up an error. Any help would be most appreciated.
Cheers Bob

 

[boblarson]

You should be able to do multiple field sorting by setting multiple fields separated by a comma.



Me.OrderBy = "[Field1] DESC, [Field2]"

 

[twosides]

Bob I have tried this but it only sorting in ascending order and not descending.
Any ideas?
Thanks

Private Sub MasterLbl_Click()
If Me.OrderBy = "[MastRef],[SubRef],[DiffRef]" Then
Me.OrderBy = "[MastRef] DESC,[SubRef] DESC,[DiffRef] DESC"
Else
Me.OrderBy = "[MastRef],[SubRef],[DiffRef]"
Me.OrderByOn = True
End If
End Sub