greaseman
Closer to seniority!
- Local time
- Today, 11:43
- Joined
- Jan 6, 2003
- Messages
- 360
I've got several reports, some of which report for a selected date range, and others that don't use a date range. All of the reports are fed by their respective queries.
In the queries that need a specific date range, I'm using the "Between [Begin Date] and [End Date], which works fine. Incidentally, these queries use Grouping and Count functions.
I'm trying to change the date-specific queries thusly: Put in a date table that contains the required FromDate and EndDate, and change the logic in the queries to say, "Between [TableDates].[FromDate] and {TableDates].[ToDate], with my intention being to eliminate the need for typing in start and end dates repeatedly and instead use a little date table to do the same thing. However, when I do this, I get an error message similar to this:
"You tried to execute that does not include the specified expression 'Between [TableDates].[FromDate] and {TableDates].[ToDate] as part of an aggregate function.'
Can anyone out there explain what this means, and what I might do to resolve the error? I sure would appreciate all the help I can get.
In the queries that need a specific date range, I'm using the "Between [Begin Date] and [End Date], which works fine. Incidentally, these queries use Grouping and Count functions.
I'm trying to change the date-specific queries thusly: Put in a date table that contains the required FromDate and EndDate, and change the logic in the queries to say, "Between [TableDates].[FromDate] and {TableDates].[ToDate], with my intention being to eliminate the need for typing in start and end dates repeatedly and instead use a little date table to do the same thing. However, when I do this, I get an error message similar to this:
"You tried to execute that does not include the specified expression 'Between [TableDates].[FromDate] and {TableDates].[ToDate] as part of an aggregate function.'
Can anyone out there explain what this means, and what I might do to resolve the error? I sure would appreciate all the help I can get.