Sorry I just saw your reply.
Append queries much to my chagrin do not persist data. Instead each query provides a new result thus destroying data that was present in the previous refresh but not present now.
I would really love to learn how to do this in Access since it seems a more robust and...
From my testing it would seem they do recognize their own code back without issues.
Also, good eye, each product has two items in the media field at least. 1 photo (PNG) and 1 video (MP4).
I tested this by purposely deleting all of the data in the URL field, watching all the items lose their...
Hello, I am absolutely brand spanking new to Access so I thank you for your patience with me in advance.
I am glad to look up any fundamental items or processes I may not know to make this work but so far I have spent lots of time trying to come up with a solution for this issue.
So here goes...