- Local time
- Today, 04:30
- Jan 14, 2017
jdraw method is the simpliest.
When i post vba against sql some wise guy react. now sonebidy post vba, approved without thinking?! Who are you?
Both jdraw's method and mine work well.
The only reason I prefer mine is that there is no need to create a temp table.
As for the second sentence arnelgp, the recent comments were about you using VBA functions unnecessarily when a simpler solution is available.
Nobody objects to the use of VBA when that is the best solution.
And what are you on about here....
...approved without thinking?! Who are you?