Append if not already existing query question?

[What-a-Tool]

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

[Tom van Stiphout]

On Thu, 17 Mar 2005 21:38:58 -0500, "What-a-Tool"
<Di************ *************@I HateSpam.Com> wrote:

In SQL you have to do that in two steps:
1: determine if the record exists, using a Select query.
2: run either an Update query or an Append query.

-Tom.

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

[Ken Snell]

If the new record contains data that would duplicate existing data in a
field that is indexed as "no duplicates", an append query will discard the
duplicate records and not append them. Thus, depending upon the data, it's
possible that this process can be done just with an append query.

--

Ken Snell
<MS ACCESS MVP>

"Tom van Stiphout" <no************ *@cox.net> wrote in message
news:44******** *************** *********@4ax.c om...

On Thu, 17 Mar 2005 21:38:58 -0500, "What-a-Tool"
<Di************ *************@I HateSpam.Com> wrote:

In SQL you have to do that in two steps:
1: determine if the record exists, using a Select query.
2: run either an Update query or an Append query.

-Tom.

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

[Tom van Stiphout]

On Thu, 17 Mar 2005 22:19:01 -0500, "Ken Snell"
<kt***********@ ncoomcastt.rena etl> wrote:

You may be right. One would hope (and I was expecting) that a proper
db design was already in place. I took the OP's comments a bit more
liberally. Surely if he wanted to add an EXACT duplicate record, or
even exact duplicate values for the unique index column(s), we would
all scratch our heads...
Upon re-read it's indeed not clear he would want to update if the
record already exists.
-Tom.

If the new record contains data that would duplicate existing data in a
field that is indexed as "no duplicates", an append query will discard the
duplicate records and not append them. Thus, depending upon the data, it's
possible that this process can be done just with an append query.

[pietlinden]

if you don't have the unique index Tom and Ken are talking about in
your table already, you can use the Find Unmatched query wizard to find
the records in the one table that aren't in the other. then turn that
into an append query.

[What-a-Tool]

"What-a-Tool" <Di************ *************@I HateSpam.Com> wrote in message
news:7br_d.6701 4$SF.42077@lake read08...

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

[Ken Snell]

If you want to change data that are already in a record, you use an update
query.

Update queries are supported by SQL in general -- they're not unique to
ACCESS.

--

Ken Snell
<MS ACCESS MVP>
"What-a-Tool" <Di************ *************@I HateSpam.Com> wrote in message
news:VPy_d.6702 5$SF.10217@lake read08...

"What-a-Tool" <Di************ *************@I HateSpam.Com> wrote in message
news:7br_d.6701 4$SF.42077@lake read08...

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

[What-a-Tool]

Finally found the old post I was talking about.
It was an UPSERT query I was trying to remember the name of.

Not what I need, but at least now I have stopped that damn itching in my
brain.

Thanks for your help

"What-a-Tool" <Di************ *************@I HateSpam.Com> wrote in message
news:7br_d.6701 4$SF.42077@lake read08...

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