Hi...Thank you for your response.
I am looking to accomplish something slightly different. I am having to build a report that looks at data for a date range like the solution you mentioned above but with additional criteria.
Selecting a Date range of data. Within that population of data, I need to count the number of records around 1st, 15th, and 25th.
If any data that has a date on either 1st, 15th, and 25th that falls on weekends or holidays, then also include the data for the weekend and for the next business day. For example, if I have 2 records that falls on the 1st and that happens to be on a saturday. The total count would be 2 records on saturday + # of records on sunday + records on monday. If monday happens to fall on a holiday, then count tuesday and so on. Instead of building the logic to count these records, I'd like to build a paramatized report that allows the user to select the date they want to include on the report.