M
Mike
Yes it is. Right-click anywhere in the current query
result set and click Edit Query. In the Criteria Field
area you probably have YourDate = #2003/07/15# or
something (or you can edit directly from the SQL). Change
the physical date to [?]. Click File/Return Data to
Excel. You'll be prompted to enter a date, do so then
click OK. You'll be brought back to Excel. Right-click
the query result set again, this time select Parameters.
Click the Get the value from the following cell option,
pick the cell where you have your date, click OK.
result set and click Edit Query. In the Criteria Field
area you probably have YourDate = #2003/07/15# or
something (or you can edit directly from the SQL). Change
the physical date to [?]. Click File/Return Data to
Excel. You'll be prompted to enter a date, do so then
click OK. You'll be brought back to Excel. Right-click
the query result set again, this time select Parameters.
Click the Get the value from the following cell option,
pick the cell where you have your date, click OK.