Search results

Hi All. Thanks very much for your input. This request has been resolved, arnelgp helped me set up a report and sub-report that gives me exactly what I need. Best to all, this was a great experience. - Charlie

Wow arnelgp, this is great, thank you ! Gasman, understood.

Hi arnelgp. The DB is attached. The only changes from what you last provided are that unneeded tables have been deleted and duplicate rows have been eliminated from the cmx table. In your update, would it be possible to also increase the number of issues per row from 7 to 10, and to eliminate...

Thanks, much appreciated. It's too big to send, let me get rid of unnecessary stuff in the DB and try again. I'll be back at my desk tonight and look at it then.

Am I able to register my appreciation for your help? I'm a newbie here, I don't yet know how to do that.

Wow ... agpReport works now, looks great !! Sorry for my earlier reluctance. Thanks so much, this is great!

Thank you arnelgp. agpReport returns only titles on my end and I very confused in trying to understand the processing. This is way over my head although I certainly do appreciate the work and caring that went into this. arnelgp and Gasman, please can we revisit my last post? I've...

Hey Gasman and arnelgp, you have both been a great help to me, thank you so much! So ok, it’s getting there, with one problem remaining. Please see the attached DB and explanatory PDF. Best, Charlie

BTW, I fixed all the records that had no issue number. Titles with " ' " in them also caused issues, I fixed those as well.

Thanks, will do ! It will be a few hours before I can get back to it, will post here when I do.

Thanks , DB is attached. Nothing confidential except maybe how bad I am at housekeeping :) The table is w8A and the query is w8a_q1. Very much appreciated !!

What would I need to do to get all issues printed across however many rows would be needed to display them all?

Hello again. Things were looking good but then I realized the query is only returning the first 7 issues for each title. For instance, in the Avengers line below, only the first 7 issues are listed but there are 125 issues in the table. Similar for Batman and all others, no more than 7 issues...

Thanks !

Ah, the modules and queries came from arnelgp, I hadn't realized. Thanks much to you too arnelgp! I do have one more question, how do I increase the spacing between the issue numbers on the query results? I tried adjusting the spaces between quotes and seem to have messed things up. Thanks.

Yayyy !!! The query runs on a subset of my table. So yes, looks like I have a data problem. The issue field is a text field because the issue designations are not always numeric (i.e., Annual #1, King Size Special #1, etc.) qty should be numeric, thanks. fyi, the access db was an external...

Title and Issue are both short text. But wait, see below the image .... I brought your sample Table1 over to my Access db and your query unedited runs fine there. I think that tells me that I brought the two modules over ok and that the issue may be within my cmx table. Any thoughts...

Ok, thanks I did that. Now I am getting this error when I run the query: Here is how I modified your query - I just changed Table1 to cmx (cmx is the name of my table) SELECT cmx.Title, fnGroupBy(ConcatRelated("Issue","cmx","Title = '" & [Title] & "'","",","),7,",") AS Expr1 FROM cmx GROUP...

Thanks. How do I include them? (I am over my head) Thanks !

Thanks ! The query is enough for me. Do I still need the modules to make that work?