MS Access Question

Factual Questions
21

I’m not sure if you’re asking me or Libertarian. Here is my query with the substitutions. You will have to replace tablename with the name of the table (or query) that you are analyzing. You will still need CommaList function from above.


SELECT tablename.Website,
CommaList("tablename","Webmaster","Website",[Website])
AS Expr1
FROM tablename
GROUP BY tablename.Website;
22

Zot… Again, idiotic question, but when I run the query, it tells me undefined function. Where do I put the code for the function?

23

Click on the Modules tab in the database window. Click on the New button to create a new module and paste the code for the function into the module.

24

That’s what I did at first. It doesn’t work.

25

By jove, man… It works. You are my new God.

The problem I had was that I called the module the same thing as the function. I also had to go change all the Null values to “Unknown”, which I was gonna do anyway.

THANK YOU.

26

Glad to be of service.

– Zot (God of Procrastination)