Search results

Yup, Ontarian is a word (now it is, anyway, LoL). Hope you had a Merry Christmas and will have a Happy New Year!

I used to do a bit of basic SQL 15yrs ago but INNER JOINs were always my stumbling block: I understood what they did, but I could never get the coding right. And, of course, anything more than basic functions and my scripting knowledge and experience failed. @theDBGuy, thanks again

You're absolutely right, he deserves more than just a thanks. And, sticking to it, me, a newbie (with some basic knowledge, enough to make me dangerous), I couldn't believe that he was still stuck on the scent until the rabbit was found! How do I give his reputation a boost for this?

The other script that I tried to make work had an interesting option (that I wasn't going to use) but the last separator was " and " instead of ", " so the results might be "author1, author2 and author3". Like I said, that wasn't an option I needed now but I guess the script author thought that...

There was just one minor change I had to make to the script, I don't know if you want to fold it into your web page but I wanted ", " between names, not just the "," so I modified the separator to include the space and tested it, it worked fine.

That's it! Wow, that was quite the effort and I'd be amiss if I didn't attribute 99.99% of the effort to you. Many, many thanks.

Hah! Absolutely perfect!!

Oooops, didn't compact and repair but just zipping it was sufficient to bring it down to the right size.

Here's the db The data is public, I'm not concerned about sharing real data.

No, there's a syntax error and I'm wondering if there might be a problem with the quotation marks around the text. I dropped the joining of last and first names and got past that error with the following code but still another error. SELECT PUB_PUBLICATION_CONTRIBUTOR.PUBLICATION_ID...

Yes, it is. Just a sec

No errors in the attempt, per se, but it was asking for a PERSON_ID which, it turns out also is text (why did they create IDs that are text and not numeric? ... anyway)

OK, here's the table structure. Ultimately, I want "PERSON_LASTNAME PERSON_FIRSTNAME" (space between them and comma between each person) I'll try that code in just a sec

No, not quite. Test should have only 3 values but instead it has all of these...

Works! What did we miss in the SQL?

Here is a screenshot

It is having trouble with 'PUBLICATION_ID FROM PUB_PUBLICATION_CONTRIBUTOR', MS Access database engine cannot find the table. I've checked the spelling, it's all good. I changed that snippet to PUB_PUBLICATION_CONTRIBUTOR.PUBLICATION_ID but still doesn't work (the dot format is what Access...

BTW, the publication ID is text, not numeric (I have no idea why but this publications database is like the 4th or 5th generation of the original which was created in the mid- to late-80s). I could change the ID to numeric but when I need to grab the tables from Oracle again, it'll be in text again.

Yup, module was SimpleCSV, changed it to modSimpleCSV. Error above didn't occur again. Not sure what you mean by Immediate Window so I couldn't do the print code. I ran the query, back to the same errors as for the previous script CONCATENATE.

Error message: Undefined function 'SIMPLECSV' in expression. SELECT PUB_PUBLICATION_CONTRIBUTOR.PUBLICATION_ID, SIMPLECSV("SELECT PUB_PERSON.PERSON_LASTNAME WHERE PUB_PUBLICATION_CONTRIBUTOR.PUBLICATION_ID=" & [PUB_PUBLICATION_CONTRIBUTOR.PUBLICATION_ID]) AS Authors FROM...