Search between two dates

[David494]

Hi everyone

I've got information in a SQL Server Database. I'm viewing the data
using MS Excel, e.g Data, Get External Data, Create New Query (on the
toolbar).

Now using the wizard I have got to Microsoft Query. What I want the
system to do is.....

When I open the spreadsheet a pop up box appears where the user types
in the FROM date, then a second pop up box appears where the user types
in the TO date. The values that are shown on the spreadsheet are the
values between the two dates (including the FROM and TO dates).

Is this quite easy?

Thanks for any help

David

 

[Gary Brown]

You need a parameter query,

Once you have connected to your database and selected the table(s).
View the Conditions and select the date field as a condition. Then
enter the condition with square barckets ([]) This creates a parameter
query, when you return the data to Excel, you will need to enter the
parameter value, however when in Excel you can set the parameter to
refresh the query, when a cell value changes (ie your date)

Good Luck

Gary