Got a problem extracting the first part of a post code so it can be matched to the post offices SSC codes.
I've tried this:-
Query SELECT ssccode([post_code]) AS [ssc code], Friends.Post_Code
Module :- Public Function ssccode(post_code As String) As String
Dim casework As String
Dim work As String
casework = post_code
Select Case casework
Case casework Like ("DA1 " & "*")
work = "74511"
ssccode = work
I need to update a field in the Friends table to include the SSC Code......
Any ideas ???