nancybrown
Well-known Member
- Joined
- Apr 7, 2005
- Messages
- 868
I have a visitor table with start date and end date fields. A "DAILY" report is generated by entering the new date in a parameter box, e.g., tomorrow's report would have 12/2/05 entered into the parameter box. All visitors for that day appear on the report.
Currently if we have a visitor that is here for 10 days, we have to manually enter each 10 days worth of dates in order for the dates to appear on the e DAILY report. Is there an easier way? I tried using an ActivX Calendar, but it doesn't add a new record to the table with each subsequent date, it only increases the start date by one.
Thanks in advance.
Currently if we have a visitor that is here for 10 days, we have to manually enter each 10 days worth of dates in order for the dates to appear on the e DAILY report. Is there an easier way? I tried using an ActivX Calendar, but it doesn't add a new record to the table with each subsequent date, it only increases the start date by one.
Thanks in advance.