Reply to thread

Message: [QUOTE="Uncle Pete, post: 1923655"] Folks, Thank you for your responses, but they don't get me where I want to go. Here is some additional info: At last count I have 27 different query/reports that need to be run from this data every month. Some times I need to go back and get earlier month's data. I would also like to macro some of these together. That's why I want to *explicitly* state the month I'm looking for *one* time and have it apply to all queries, hence table 3. I'd rather not have to enter the month 27 times as the queries run and I don't want to use anything involving the current month because that may not be the one I'm looking for. Tom Lake: I know, but if I can get the month selection right, I can fix the year in a similar fashion. Thanks Again Uncle Pete [/QUOTE]