Using Excel Form to Select Parameter for MSQuery Sheenalis 26.07.2006 15:46:02 I have queries which have SUMREV01 SUMREV02, etc. as fields. I'm creating a monthly report in excel which pulls this Revenue data from access using msquery. I want my boss to be able to select which month she'd like the data for on a form in Excel and it pull the correct data. As the Revenues from different months are different fields instead of criteria...I'm not sure how to do this or if it's possible. I know I may have to use VBA but I'm not extremely familiar with it? Is there any easier way or what is the simplest way of accomplishing this? Thanks! -- whitney

RE: Using Excel Form to Select Parameter for MSQuery Klatuu 26.07.2006 17:53:01 Since you are wanting to do the work in Excel, perhaps you may get a better answer in the Excel news group. "Sheenalis" wrote: [Quoted Text] > I have queries which have SUMREV01 SUMREV02, etc. as fields. I'm creating a > monthly report in excel which pulls this Revenue data from access using > msquery. I want my boss to be able to select which month she'd like the data > for on a form in Excel and it pull the correct data. As the Revenues from > different months are different fields instead of criteria...I'm not sure how > to do this or if it's possible. I know I may have to use VBA but I'm not > extremely familiar with it? Is there any easier way or what is the simplest > way of accomplishing this? > > Thanks! > -- > whitney

RE: Using Excel Form to Select Parameter for MSQuery Sheenalis 26.07.2006 19:09:01 Thanks, I'll try that. -- whitney "Klatuu" wrote: [Quoted Text] > Since you are wanting to do the work in Excel, perhaps you may get a better > answer in the Excel news group. > > "Sheenalis" wrote: > > > I have queries which have SUMREV01 SUMREV02, etc. as fields. I'm creating a > > monthly report in excel which pulls this Revenue data from access using > > msquery. I want my boss to be able to select which month she'd like the data > > for on a form in Excel and it pull the correct data. As the Revenues from > > different months are different fields instead of criteria...I'm not sure how > > to do this or if it's possible. I know I may have to use VBA but I'm not > > extremely familiar with it? Is there any easier way or what is the simplest > > way of accomplishing this? > > > > Thanks! > > -- > > whitney