Search results

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…

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...

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...

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.

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...

@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... :(

@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...

@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...

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 =...

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.

Yes, sorry: I believe I can do that so I will try it today night and I will let you know. Many thanks! :)

Ah, sorry! I overlooked your post, sorry… it is quite interesting solution! I will try it :) Thanks a lot!

My mistake. I didn't made myself clear… 1) I already have table where all authors are (i did it in Excel) so I have like AuthorID LastName 1 Brown 2 Lavender 3 Peach 4 Bleach Etc I have junction table (I want to populate): PublicationID <> AuthorID What I want to do by VBA...

Thanks DocMan! well this is jist part of my problem. The other thing is that I want to find that extracted name in table of cleaned names and eventually run append query. My idea is that it would work like: I have source string: Brown AJ;Peach P;Lavender KL Now I run first loop and I extract...

Hi! I have bloody dirty database which I'm trying to clean up. It is basically reference management database I created by export of my references from EndNote. My issue is that AUTHORS Field (which is temporary until I do cleanup) is string of concatenated authors with “;”as separator. It is...

Thanks a lot for this guidance. I'll try to design it like that!

Just one comment on my one-to-one approach, also related to nulls: it was my intention to save some data. In case I have 8000 transactions so far but only in 1% of them I use particular field it seemed to me to be a good idea to "clean" those data to "table extension" and when needed to recall...

@gemma-the-husky it is purely personal thing, so no rigorous accounting is needed. I'm using Access as database and then visualize data in Power BI Desktop. @Pat Hartman yes, tblExpenses where all transactions are stored is crucial for me. In this table I categorize every transaction. All I...

Thanks all of you gentlemens! Well, I tried to put your proposal to scheme so I can imagine it little bit more, but still I don't think I get it right. What I understand from @gemma-the-husky and @MajP it is this scheme: tblExpenses (Entity table) 🔑 ExpenseID (PK) Category Note Value...

Hi! I would be very grateful for your help regarding my issue: I have Expense Tracking Database. Main Table is list of Expenses with value of transactions: tblExpenses ExpenseID (PK) CategoryID (FK) Note (text) Value (Currency) 1 1 Bla bla bla -256 USD For a lot of expenses in this...