Hi Phil, I do use 'try .... otherwise' in certain areas, but as I understand it I can only use that construct over individual lines of code. That wo...
Hi Phil, I'm rather constrained on what I can share due to company rules. The key thing I'm trying to understand is how to 'trap' an error that oc...
Thanks Mynda,
Hi Mynda, Absolutely happy with your placing the post wherever best suits the forum. You commented that I "..need to ... is alter the filters af...
Thanks Mynda, I have never yet had occasion to really use them. However, I've just had a quick look at a blog (on
Hi Mynda, Finally fixed it. I had to extend the M2M concept to manage also at the Sub-Section level. This resulted in a more complex Diagram view...
Hi Mynda, Firstly apologies for delay in replying, we've have internet/phone problems. I've used PQ to create the qryDailyBudget which has an en...
Hi Mynda, Thanks for the quick reply - I'll investigate using Powerquery to add the dates as the users would be confused if I included it on the bu...
Thanks Phil, much appreciated - I wish I'd realised it was that simple. I'm learning. Many thanks.
HI, I believe I've found the answer and am posting in case it helps anyone else with the same problem: 1. Group by Download File, Date, Retailer...