Crystal Reports - Select data in table based on current week number and business days
Posted on 2010-04-07
Have an access DB that has the following fields:
callschedule : (weekly, bi-weekly, 1st of month)
dayofweek : (monday, tuesday, wednesday, thursday, friday)
I need to create a report that will run daily to provide a list of customers they should call that day. With the filds listed is that possible? If not should I redeisgn the table data?