idk how to do it with a slicer but if you just add a pivot table filter, the filter will live in a cell, and you can just pop in a macro whatevercell.value="blah blah blah" and it will do the filter without much problem. If it's a presentation layer issue I know you can also hide the row with...
I'm not following.
If you're trying to join data between "source file" and "city master", I guess I would probably create two recordsets and use a temp table or maybe recordset.fields.append to bluff a join.
Kenneth: Output will be 2 different cells. The output is going to get fed into our ERP environment.
Naray: the code can do the sort if need be. But ‘as it is found’ it will be unsorted.
Hi,
I'm struggling mightily to wrap my head around this one. I've got ideas, but every time I sit down to do it I end up going down a rabbit hole. I've got a bunch of numbers like:
1
2
3
9
14
15
16
19
I want to parse them as a FROM and a TO like:
From To
1 3
9 9
14...
power query and power bi are both free. Power Query is strictly query plus some pretty functional transformation functions. Power BI contains the same functionality as powerquery but also adds nifty dashboardish type display.
So---I've got a coding problem. I've got a solution. I'm looking for a second opinion if this is the right way to handle it, or if there's a better way:
The set up:
-It's access. The code lives in a class.
-The overall process is:
1) Feed the class a bunch of parameters
2) A...
Maybe a guru level sql guy could do something with this. My approach might start with sql to fetch the right data but for adding logic to the output you might be best off with a recordset. You could pretty reliably get the data, loop through it and account for various conditions, and construct...