Recent content by Noruen

  1. N

    Concatenate values from detail section in group header

    Ok, thank you all for explanation! I hope I’m smarter and now I will go find that discussion with TheDocMan. I’m quite curious. btw @MajP I tried yours and @arnelgp solution today and it seems they, at least now, are comparable in speed and uncomparably faster than Allen Browne’s. That...
  2. N

    Concatenate values from detail section in group header

    @Pat Hartman I will try both solutions just on tomorrow :) this is quite interesting discussion I can’t probably fully appreciate, but it is amazing how deep into Access you see! If I may, @MajP @The_Doc_Man & @Pat Hartman: I have had no idea Report works differently than underlying Query (to...
  3. N

    Concatenate values from detail section in group header

    @MajP I have never said your solution was bad for me. Never. My basic question was if I can use underlying recordset to perform concatenate function. I tried Allen Browne's function and it made my Report slow. I'll definitely experiment with your solution if, for any reason, would it be better...
  4. N

    Concatenate values from detail section in group header

    Thanks @MajP However you use custom recordset in your function. Is there any way how to use Report Recordset? Maybe I need to be more specific: When I put SUM to report group footer Access will sum just values of specific group. Something like SUMIF analogy from Excel. So is there any way to...
  5. N

    Concatenate values from detail section in group header

    My thoughts were something like Public Function ConcatValues(strField As String) Dim rs As Recordset Dim strResult As String Set rs = Report.Recordset For Each rs!TagName strResult = strResult & "; " & rs!TagName Loop etc... However I have no idea how to do it with...
  6. N

    Concatenate values from detail section in group header

    And I appreciate it, there was not intention to be offensive in any way from my side! 😰 I just don’t know how to concatenate values in footer anyway…
  7. N

    Concatenate values from detail section in group header

    Sorry, I probably didn’t made myself clear. I know there is not built-in fuction for that. But Access has functions like “First” that will choose first value in group or Sum that will sum up all values in group, etc. So the problem I’m asking about is how to write function that will instead of...
  8. N

    Concatenate values from detail section in group header

    I thought this kind of feature would be great for such things like when you have (limited number) of tags for example: so that tags that would be listed one by one on separate rows in detail section would be concatenated in particular group header. @Pat Hartman so it means values from recordset...
  9. N

    Concatenate values from detail section in group header

    Thanks all of you, but what I’m trying to reach is that in every group it will concatenate values from detail section, not all values in header or concatenate values from different fields.
  10. N

    Concatenate values from detail section in group header

    Hi! I’m just wondering if there is any way how to use some kind of “ConcatRelated” function (you know, from Allen Browne) in report so that values from detail section would concatenate in particular header. I mean, if Access can sum values, show me the first or last value, etc, there must be...
  11. N

    Compare string with records in table (query?)

    @MajP sorry for my silence, I have shitstorm in the job so I will get to your improvements hopefully soon. Please do not take it as disrespect to your help... :(
  12. N

    Compare string with records in table (query?)

    @MajP very nice! Well, reason for ID > 150 is simoly that it was the last pub before that append query failed because of author that had ' in its name. I have had to replace rhis symbol with small dash and then run the rest of the pubs: from 151 and above. So in fact I extracted all the...
  13. N

    Compare string with records in table (query?)

    @MajP you are very convincing. I'm sending you my whole database :) There is no secret there, but please do not vomit: I'm really building things up on the go so it is in the state of mess. tables of interest are tblPublicationAuthors and tblAuthors. In tblPublicationAuthors I have those...
  14. N

    Compare string with records in table (query?)

    Once again, thanks a lot @MajP ! I did some edits to your code as I already null-ed some of the TempAuthors fields manually and it returned error: Public Function ExtractNames() Const SourceTable = "tblPublications" Const JunctionTable = "tblPublicationAuthors" Const AuthorField =...
  15. N

    Compare string with records in table (query?)

    Amazing! Thanks a lot! Especially for that VBA part. Finally I can see how to work with arrays. You saved me many days of manual work.
Top Bottom