By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,261 Members | 1,674 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,261 IT Pros & Developers. It's quick & easy.

How to use Append Query on 00-00-000 formatted field

P: n/a
To all:

Hi! I am trying to use an append queries on a table where the key
field is numeric, formatted as 00-00-000. The query collects the
information corectly, and there are no records duplicated, but I get a
key violation each time I try to run the query. Any ideas?

More details: The query collects, concatenates, and turns the key field
to be appended into a value. I have tried formatting the query's field
as 00-00-000, as well as with no formatting.

Thanks,

Sean

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
This is just one of the problems with these home-made type primary keys.
SSN numbers need to repeat at some point; why do you think yours (with one
less character) won't. This is just another example of why autonumber
integers work as one of the best primary keys.

If the error msg is "x records not added to key violations" then you have
potential duplicates, and they cannot be added, as the key values must be
unique. You can run a "find unmatched records" query to see which ones are
dupes, or remove the key property, append the records, then search for
duplicates created.
-Ed

<st**********@gmail.com> wrote in message
news:11*********************@l41g2000cwc.googlegro ups.com...
To all:

Hi! I am trying to use an append queries on a table where the key
field is numeric, formatted as 00-00-000. The query collects the
information corectly, and there are no records duplicated, but I get a
key violation each time I try to run the query. Any ideas?

More details: The query collects, concatenates, and turns the key field
to be appended into a value. I have tried formatting the query's field
as 00-00-000, as well as with no formatting.

Thanks,

Sean

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.