AboutScottgem Expertise I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design.
Experience I've been designing databases for over 15 years working with dBase, FoxPro, Approach and Access.
Organizations Author of Microsoft Office Access 2007 VBA Techncial Editor for Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports & Queries From Que Publishing
Question I am using Microsoft Access 2002-2003 and am having problems setting up a complicated query using two different tables, News Coverage and Media Calls. I need to specify a date range and within this I need to know the primary subject, secondary subject, province, type and reach. Primary and secondary subject, as well as date, reach, province and type are in each table, but under different names for date, reach and type. Can you please help me set this up- it is one of a ton of queries I have to set up. Thanks very much.
Answer When faced with complex queries, I try to build the queries using interim queries. I define an interim query as one that is used as the source of another query. So you could have one query that just joins the tables and maybe uses one criteria. You then use that as the FROM in a second query that applies further criteria. keep doing this until you get the records you want.
