S
SteveS
I would like to set up some controls in a form to filter a query by a date
range, without using the 'Between ... And' parameter in the criteria. I would
like to do this to the query (as opposed to a report) and without a parameter
because:
a) I am using MS Excel to run some complex calculations on the queried data
via an External Data Query within Excel. The issue is that I cannot
auto-refresh the data in Excel when I set up the parameter.
b) I'm then using a Linked Table to pull the relevant results back into
Access, ultimately leading to the report and want to make sure the process is
as streamlined as possible (as opposed to running the query on all dates,
running the calculations on more data than needed, and then limiting the
results in the report)
In a nutshell, I want users to be able to enter the desired date range in a
form then be able to go to the report based on the data pulled, behind the
scenes, from Excel.
I am a fairly new user to Access (just learning the ropes) but a fairly
advanced (albeit self-taught) MS Excel user. I did read the excellent article
from Allen Browne's web site on limiting a report to a date range, and wonder
if that could be applied to a query by changing some of the code? Any
guidance would be appreciated.
Best regards,
Steve
range, without using the 'Between ... And' parameter in the criteria. I would
like to do this to the query (as opposed to a report) and without a parameter
because:
a) I am using MS Excel to run some complex calculations on the queried data
via an External Data Query within Excel. The issue is that I cannot
auto-refresh the data in Excel when I set up the parameter.
b) I'm then using a Linked Table to pull the relevant results back into
Access, ultimately leading to the report and want to make sure the process is
as streamlined as possible (as opposed to running the query on all dates,
running the calculations on more data than needed, and then limiting the
results in the report)
In a nutshell, I want users to be able to enter the desired date range in a
form then be able to go to the report based on the data pulled, behind the
scenes, from Excel.
I am a fairly new user to Access (just learning the ropes) but a fairly
advanced (albeit self-taught) MS Excel user. I did read the excellent article
from Allen Browne's web site on limiting a report to a date range, and wonder
if that could be applied to a query by changing some of the code? Any
guidance would be appreciated.
Best regards,
Steve