Search results for query: *

No worries, thanks for your time :)

Also, quick question for you, would adding a hyperlink using a hyperlink field with ctrl + k be the most effective/ safest way to add a link to a specific location? Thanks

Exactly right, that was the big issue. Oh well, time to add hyperlinks for 1000+ rows haha. Thank you for your patience and assistance throughout the past few days!

Oh, that is exactly what I'm looking for - but just my attachments aren't actually showing (as you can see they all say "0" when in reality there's 1-3 attachments per row. I will probably opt to storing hyperlinks for each row since it seems a whole lot easier. Thanks again for your assistance...

I get the merged table with both attachment fields! However, the pdf files I previously attached are not present. Please see the photo to see what I am talking about. Thanks again

Unfortunately not, I receive the error "syntax error in query expression 'U.*T1.Softcopy'. :(

Sorry, so the code would look like this? SELECT U.* T1.SoftCopy AS T1SoftCopy, GII.SoftCopy AS GIISoftCopy FROM qselGII_Softcopy GII RIGHT JOIN (qselT1_Softcopy T1 RIGHT JOIN quniTable1GIIRegister U ON T1.IDKey = U.IDKey) ON GII.IDKey = U.IDKey;

Sorry, I don't understand what you mean? The Nz() code was not used in any other queries? Thanks

By that you mean to not include the attachment column? That's a shame, I thought it could be done. Thanks for your assistance anyway, I appreciate it.

Hi guys, thanks so much for responding. Apologies for the delayed reply, I have not been in the office over the weekend. I used your exact code (as below) for the last query Dhookoom, and I received an error as follows: "The multivalued field 'T1. Softcopy is not valid in the expression...

Thanks dhookom, it now works for the first query. However, I receive the following error on the last query: Is there something that I've overlooked? Thanks again for your patience :)

And just to let you know- FYI this is my first week of using access. So please excuse my horrible explanations and me being so clueless. I appreciate your patience :)

Thanks for taking your time to reply dhookom! I truly appreciate your help! I have followed all of your code, but have unfortunately received a couple errors. For the first query you provided, I received the following error: I added the "IDKey" onto the second SELECT line code following the...

@dhookom - Thanks for the reply, I appreciate it. I have left the primary key as "ID" for both tables, where each row is given a number (i.e. 1,2,3,4...). These numbers between each of my tables have no correlation though, I'm just wanting to paste one table on the bottom of another in order to...

@Andrzejek - Thanks for your reply, I appreciate it. Correct that SQL works perfectly and joins the two tables together. However, I did not include my attachments field ([Softcopy]) within that, otherwise I would receive the error "the multivalued field '[Softcopy]' cannot be used in a UNION...

Hi All, I was just wondering if anyone can elaborate on what the code would look like for the answer by Programmer dhookom on thread700-1724615: https://www.tek-tips.com/viewthread.cfm?qid=1724615#post I know this has been answered before but I am having some struggles. This is my SQL code as...