Query to pull rpt by month from and to...HELP?

[Dedicated]

All my monthly rpts are pulled by Month (Text) in my query. I need to generate a report pulling from April thru June of 2005. Since I can't use the "Between" operator so what other options do I have? I used a separate table to list the months and then linked via lookup wizard. Should I add an additional field to make it a combo box and then add the # to correlate month? For example January 1; February 2;

Thanks,
Dedicated

 

[Trevil]

First off, I don't believe you can do a 'multi-select' on values in a combo box, so you will need a list box instead.
Then after the user selects the month(s), one option would be to have two hidden controls on your form (i.e. StartMonth and EndMonth) and have your report query select 'between' those values. This assumes you have access to the numeric month in your table.
Another option would be to have your report build a 'where' clause that allows for the alpha months.

You still would need to consider the possibility that someone decides they want to select a non-contiguous range of months (Jan, Mar, Jul).

"Hmmm, it worked when I tested it....

 

[Eupher]

Hi, Dedicated,

Why do you think you can't you use the Between operator?

Ken S.