Recent content by Splatgore

Sorry for the delay! Been crazy busy doing some other work and haven't had time to get back to this particular problem. I'll have a play with your suggestion and see if I can get it to work. It is driving me nuts but it is such a small issue in relation to the rest of the stuff I have to do I...

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...

Thanks for the tip. I'll play around with your suggestion but I am sure I will be back with more questions. :)

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...