troubleshooting Question

Microsoft Excel 2007 Query based on date parameter

Avatar of printmedia
printmedia asked on
Microsoft Excel
1 Comment1 Solution215 ViewsLast Modified:
Hi all.

I have an excel 2007 worksheet whose datasource is a sql table. The fields in that table are: ItemNumber, QtySold, Month, Year

I want to be able to have the user enter the following parameters: Month1, Year1, Month2, Year2

So if the user enters: 10, 2010, 12, 2010 the results would display data from Oct 2010 through December 2010.

If the user enters: 11, 2010, 02, 2011 the resuls would display data from Nov 2010 through February 2011

How can I do this using the query option in excel?

I tried doing this using the code below, it worked fine with my first example but when I got to the second example it didn't work.
WHERE (myTable.Month1>=? And myTable.Month2<=?) AND (myTable.Year1>=? And myTable.Year2<=?)

Open in new window

Software Professional

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros