"What-a-Tool" <Di*************************@IHateSpam.Com> wrote in message
news:7br_d.67014$SF.42077@lakeread08...
Remember seeing a post a while back from someone who wanted to add to a
table only if the data didn't already exist.
Someone suggested a type of query called an "Up" something or other. Can't
remember - could someone refresh my memory on this please?
Thanks
I have a PK identifier, and a row of fields containing changeable data. If
the PK is the same, I want to update whichever of the other fields has been
out-dated by the new data. Believe I could simply do this with an Update
Query.
But, this got me remembering the other post mentioned - I thought I saved
it, but can no longer find it. All I am trying to remember is the name of
this type of query - I feel as if it's right on the tip of my tongue, and
its bugging me. If I have the name, I can look it up in the Microsoft SDK
myself.
I seem to remember that it was a type of query that was only supported in
Access, and it was call an UP?/Something query. Can anyone help with this
name?
Thank You