Solved Append Query Key Violation (1 Viewer)

JED25

New member
Local time
Today, 14:28
Joined
Apr 29, 2022
Messages
11
Here's your original query from your first post.

Here's the working query from @Eugene-LS from post #17.

They are not exactly the same. As far as I can see, the second/working query is missing two fields from your original query.
Yes I'm trying to randomize the data so I can just send everything.
 

Eugene-LS

Registered User.
Local time
Today, 21:28
Joined
Dec 7, 2018
Messages
481
working query is missing two fields from your original query.
Ye-e-e-e-e-s-s-s-s!
That's right.
But I worked with the file that was posted and there were really two fields missing.
I didn't make it up any more ...
 

JED25

New member
Local time
Today, 14:28
Joined
Apr 29, 2022
Messages
11
Ok I randomized the data now.
 

Attachments

  • Master Data Entry - Copy (2).zip
    520.5 KB · Views: 119

JED25

New member
Local time
Today, 14:28
Joined
Apr 29, 2022
Messages
11

Attachments

  • MASTER DATA EXPORT TEST - Copy.zip
    349.8 KB · Views: 128

Eugene-LS

Registered User.
Local time
Today, 21:28
Joined
Dec 7, 2018
Messages
481

Attachments

  • Screenshot 2022-04-29 232905.png
    Screenshot 2022-04-29 232905.png
    73.1 KB · Views: 108

JED25

New member
Local time
Today, 14:28
Joined
Apr 29, 2022
Messages
11
Some fields are perplexing ...
I've tried the date/time format, but I couldn't get it to ever transfer correctly from excel without having to retype it all because I did not create the original data. I have the calculated fields because I use them for other queries and reports.
 

Eugene-LS

Registered User.
Local time
Today, 21:28
Joined
Dec 7, 2018
Messages
481

Attachments

  • Screenshot 2022-04-29 234751_000000000000000000000001.png
    Screenshot 2022-04-29 234751_000000000000000000000001.png
    52.2 KB · Views: 110
  • Screenshot 2022-04-29 234751_000000000000000000000002.png
    Screenshot 2022-04-29 234751_000000000000000000000002.png
    72.3 KB · Views: 111

Eugene-LS

Registered User.
Local time
Today, 21:28
Joined
Dec 7, 2018
Messages
481
I've tried the date/time format, but I couldn't get it to ever transfer correctly from excel without having to retype it all because I did not create the original data.
There are some functions for data transform ...
TimeValue() for example ...

...
My local time is late, I'm tired.
I leave you in the good hands of the experts of this forum.
Good luck!
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 14:28
Joined
Feb 19, 2002
Messages
42,971
We don't know what you did to resolve the problem. Perhaps you could post the query that worked.

The target fields in the table were text so there should have been no problem appending string dates there. Using your original files, the query worked for me once I got rid of the two missing fields.
 

JED25

New member
Local time
Today, 14:28
Joined
Apr 29, 2022
Messages
11
We don't know what you did to resolve the problem. Perhaps you could post the query that worked.

The target fields in the table were text so there should have been no problem appending string dates there. Using your original files, the query worked for me once I got rid of the two missing fields.
The query wasn't the problem. I had a relationship between my client IDs and they were set to double instead of long integer. Once I changed that in my original DB everything appended correctly.
 

Users who are viewing this thread

Top Bottom