Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
I have created a macro to select multiple months within a YearMonth field (2013 Dec, 2014 Jan ... etc) that contains a list of rolling months.
The macro is being called from 3 buttons for most commonly selected months ie. YTD (Jan through current month) , last 6 months and last 12 months which can span over 1 or 2 years.
Is it possible to do this selection without using a macro? (using QV built in functionality and probably variables(?))
Actions in a button allow to Select in Field whereas a field can be specified but how can a specify a range of months?
Thanks
PS the macro I have created works fine but reading some "bad" things about macros I am trying to learn the "correct" ways of moving around
All the best
Josh
I found what I needed. '(' & Concat(DISTINCT chr(39) & Field & chr(39) , '|' ) & ')'