Search results

  1. S

    Conditional Insert Query

    Hi there, I've got a query which I'm trying to write which I can't seem to get right. Basically I am trying to select a set of data from table A and insert it into another table. However, if the set of data I select returns 0 records then I want to insert a default value into the table...
  2. S

    Split / Parse a string into substrings on new rows

    Hi there, First time posting (technically second time but I lost my first post ... grr!) so be gentle. :) I have a table in Access with 2 fields; DelID (text) and AssetDesc (memo). DelID is a unique asset ID and AssetDesc is a location string which can be up to 450 chars in length. What...
Back
Top Bottom