Using Excel Form to Select Parameter for MSQuery

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
Since you are wanting to do the work in Excel, perhaps you may get a better
answer in the Excel news group.
 
Back
Top