02-18-2014 05:26 PM
HI I have a table that has these col
DAte of service ID. Days
2/16/14. T1. Sun Thur
2/16/14 T2. Sun Wed
02/16/14. T3. Sun Tue
02/16/14. T4. Sun
The report is run 2 day lag so Sun report gets run on Tue .WHat report shows is day of service at ID site Days is schedule .
THese were all done Sun . I need to pull only the ones that have next day service that is not today() or tomorrow .
THe first one i would need is the first one and the last one.
THank for your assistance
02-19-2014 12:35 AM
i was having a hard time with the ask myself ...Sorry
What is being requested is a report to determine what is next day schedule. Example
Date of Service was on Sun 2/16 I pull the report on Tue 2/17. Because there is a lag of time between uploading data. Up to this point I have the data which looks like the table I inserted . From here they want to see only the ones base on schedule for example today is tue so if its schedule today I can exclude if its schedule for tomorrow I can exclude only the ones that are schedule later in the week are needed for the report. Thanks Again
02-19-2014 06:02 PM
HI Reeza I figure it out it took some outside thinking but was able to create a macro that does exactly what I need ...I'm going to close question
Need further help from the community? Please ask a new question.