W
Whitney
I would like to be able to pull a report using today's day and have it query
the current months data.
For example, I'm creating an overall head count report, which includes
several subreports references headcount numbers, however one subreport is for
Attrition and I only want to reference the current MTD attrition. How can I
have it reference's today's date and provide the current MTD data, or use a
form to reference a date and have it return that current MTD data?
I know the basic concept of using this expression in the query
[Forms]![DailyReportDateSelector]![txtStartDate], I'm just not sure how to
tell it to query the whole month.
the current months data.
For example, I'm creating an overall head count report, which includes
several subreports references headcount numbers, however one subreport is for
Attrition and I only want to reference the current MTD attrition. How can I
have it reference's today's date and provide the current MTD data, or use a
form to reference a date and have it return that current MTD data?
I know the basic concept of using this expression in the query
[Forms]![DailyReportDateSelector]![txtStartDate], I'm just not sure how to
tell it to query the whole month.