Using Excel Form to Select Parameter for MSQuery

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

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using a Form for Parameters 3
Returning data to excel from msquery 1
Prompting for parameters in MSQuery to pass into a stored procedure 4
Use Excel as data entry form 2
allow user to select range in Excel worksheet from Access form 4
Passing a Parameter into a MS Access 2007 Form 0
Export Data from an access table to a pre-formatted excel template 1
Exporting query to excel 36

Top