Search results

HI, I am writing a query which split fullname field into separate columns(firstname,middlename,lastname,title or suffix). Here is my query so far and it seems to be working fine except for the ones with title or suffixes. Query: --------- SELECT Participants.[Full Name], GetNamePortion([Full...

HI, I am trying to use openrecordset to access query fields but nothing happens. What am I doing wrong? Public Function test() As String Dim db As DAO.Database Dim rst As Recordset 'Dim qryfld As DAO.QueryDef 'Dim fld As Field Set db = CurrentDb() Set rst =...

Hi, I have a field with multiple values in it(for ex: address with street,state,zip etc) which is in JSON format. I need to split this into multiple fields. Some of the columns may have multiple addresses also. Those needs to be created in a new row. any ideas would be appreciated.:banghead...