Consecutive dates in report

eacollie

Registered User.
Local time
Today, 13:12
Joined
May 14, 2011
Messages
159
Is it possible to list out each consecutive date in a report when given a range of dates without having to create a table of dates?

For example, given the date range 12/01/2013 to 12/05/2013:

In report:
12/01/2013
12/02/2013
12/03/2013
12/04/2013
12/05/2013

Is it possible to do this dynamically in vba?

I want to ultimately join this to a recordset for the report.

Thanks!
 
Not to my knowledge. In that situation I use a date table that I empty and populated with the range entered by the user before running the report.
 

Users who are viewing this thread

Back
Top Bottom