Status: Co 810950 00 Given the following Access SQL SELECT statement: SELECT eventrequest.eventno, custname, contact, dateauth FROM eventrequest, customer WHERE eventrequest.custno customer.custno AND status- Approved" AND eventno NOT IN ( SELECT eventno FROM eventplan WHERE workdate BETWEEN #10/1/2007# AND #10/31/2007#)