This video was created by John Coverdale to document the steps needed to workaround a problem with Access Project 12 B in CIS 1A

The problem: After April 2009, the Project 12B "Current Events" Query and "Current Events" Report do not display information even when using the data supplied by the textbook instructions. (This occurs on page 895, compare with Figure 12.50)

The reason: The "Current Events" Query only selects future events. The data provided by the book's instructions include only events dated before May 2009 (now in the past).

The solution: Modify all event dates in the "Events" Table so that the "Start Time" and "End Time" occur in the future. The student results should then match the pictures in the book.