Make a query named SalesmanQuery1, add both tables. In the query only add the date field from your other table and one of the fields that have your ID for your salesmen. Under the date add this criteria 01/01/2007. Right click and add grouping. That way it will only list one record per salesman. So then you will have a list of salesman from the field you selected that have records in
Here is what you would do. Copy your current salesman table, then paste it and just add a 2 at the end of the name. Now you have tables Salesman, and Salesman2 that are exactly the same. Open Salesman2 and delete all the records. Next add the two new columns, SalesmanID with datatype autonumber, and Active with datatype yes/no and set the defauilt value to yes. Make SalesmanID your primary
************************************************************** JobCircle.com is a regional job board serving all industries and occupations in the PA, NJ, DE, NY, MD, and DC areas. We offer a regional job board, online learning, and regional job fair events for jobseekers who live in our areas of focus. To Learn More: Job Board: http://www.JobCircle.com?source=ng eLearning
http://www.thenation.com/doc/20080519/klare The New Geopolitics of Energy By Michael T. Klare This article appeared in the May 19, 2008 edition of The Nation. While the day-to-day focus of US military planning remains Iraq and Afghanistan, American strategists are increasingly looking beyond these two conflicts to envision the global combat environment of the emerging period--and the world
************************************************************** JobCircle.com is a regional job board serving all industries and occupations in the PA, NJ, DE, NY, MD, and DC areas. We offer a regional job board, online learning, and regional job fair events for jobseekers who live in our areas of focus. To Learn More: Job Board: http://www.JobCircle.com?source=ng eLearning
