Ginger:
I am having the same issue and wanted to ask you for more detailed instructions. I also have several fields and hundreds of records for which I have to show the fields and the dates between the start and end date, but not including the end date. Thanks.
josheppi
Geoff:
Thanks for reply. I am using MS Access and seem to lack some of the functionality used in your example. Also, I have a table with hundreds of records with date ranges. Do you think I can still define date1 = [RCT].admit_date?
I have a table with a date range (name, date1, date2, diff). I would like to list out all the dates between the range beginning with date1 but not including date 2. So if date1=1/1/05 and date2=1/5/05, I would like get the following info:
col1 col2
name 1/1/05
name 1/2/05
name 1/3/05
name...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.