Using Excel Form to Select Parameter for MSQuery

S

Sheenalis

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!
 
K

Klatuu

Since you are wanting to do the work in Excel, perhaps you may get a better
answer in the Excel news group.
 
S

Sheenalis

Thanks, I'll try that.
--
whitney


Klatuu said:
Since you are wanting to do the work in Excel, perhaps you may get a better
answer in the Excel news group.
Click to expand...
 
Top