Hi there, I have a problem with my syntax I think... actually its probably more but I am too inexperienced to know it. I can obtain a result with the following: Code Snippet Dim TEST2 = From client In db.clients _ Select client.client_no, _ accountType = client.type, _ Name = If (client.first_name = "" , client.last_name, client.first_name & " " & client.last_name), _ address = concatinateAddress(client.address1, client.address2, client.suburb, client.state, client.postcode), _ phone = client.phone_business,
Read More...