Search results

  1. G

    How to exclude null value records from query results

    Hi, one of the fields in my query is calling a function which returns a string value or null values. I want to exclude records that has null value in that field. I do have alias name to that function for that field. This is how I am writing the where condition in the query. where aliasName>...
  2. G

    create multiple rows from a column data

    HI, I have a query which has few temp columns that call one of my functions. What the function does is, it takes a field value for example address field is passed into the function, and then I am using vba json parser to parse address field and then store appropriate value into the calling...
  3. G

    need module help in splitting a field

    HI, I have been working on a module to split an address field into multiple columns. I am fairly knew to ms access but gained some knowledge in the past couple of days and I do have programming knowledge. I have written a couple of functions to split an address field which has street address...
Back
Top Bottom