I have a database that consists of 7 tables all linked by a school id number. The other tables hold data related to the schools. Another field common to all the related tables is a date field. I could use some direction on how to structure a query that selects data by school and a specific year. The related tables hold data for a number of years and I need to query and report by school for a given year. My main table holds generic school info. The other tables are linked by school_id and have a year field. I have a query that holds all the data - the trick is how to get the data filtered by year. Thanks for getting me started.