Search results

Like JHB says, 1000k :rolleyes: I dont need to match them all, but I need a good sample size of matches (near 50k)with as little selection bias as possible. I will continue the struggle, but I have a question.. How would a query look that selects t1.ID if t1.x, t1.y and t1.z match t2.x...

Thanks for your reply. AcademicPublications is around 480k and Patents will be 1000k. There is no common field sadly. I liked the idea of extracting the information into new columns first, as much as possible and started on it. Overal, I'd say there's 3 dominant ways of writing the...

I have been able to extract Author and title (split left and mid on " (chr34)). Both are rather messy but I'd guess that 90% is correct. The issue however is that too many observations do not have a title and FirstAuthor on itself is not good enough if its not missing. The most unique and...

I've manually looked up some matches, in attachment 1 you can find what I would see as ideal outcome table. In attachment 2 i explain it further: The columns with a red frame are from my AcademicPublications table, the columns with a blue frame are from my Patents table. You can see that...

For my study on academic research I need to match patents that refer to academic research as prior work with the actual prior work. I have two tables (see attached images below). One regarding AcademicPublications (AP), which is neatly organized with title, year, journal, volume, pages, first...

Thank you, I will look into it.

Hi there, I'm currently busy with something for my thesis as a student and I need to use Access for this. I'm not too new at access, I know how to do the very basics, let's say on the level of [if field contains *"text*", return x]. However I am struggling right now on something that shouldn't...