Multiple Selection Within a Field

[jduenyas]

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

[b_garside]

I found what I needed.  '(' & Concat(DISTINCT chr(39) & Field & chr(39) , '|' )  & ')'