Hello, I have the following on a form to update a field on a form, but I want to make it an Update Query instead. I've tried using the Builder option but haven't been successful. Any ideas on how to translate this in a query?
If IsNull(Me.Underground) And IsNull(Me.Overhead) Then
Me.SCOPECAT = Me.Station
ElseIf IsNull(Me.Station) And IsNull(Me.Overhead) Then
Me.SCOPECAT = Me.Underground
ElseIf IsNull(Me.Station) And IsNull(Me.Underground) Then
Me.SCOPECAT = Me.Overhead
End If