My master table is called projects. Each project has many invoices and many foreman assignments. Foremen are measured by tracking how much revenue they generate during a date span. I need a report that shows me the invoices that went out during the date span that were for projects assigned to a particular foreman. I envision <ask the user> for the foreman name, date on or after and date on or before. The Foremen table is also a master to foreman assignments. Column headings would be Project Name, Project #, Invoice date, Invoice Amount. Group and sort by Foreman name. I am stuck. Thanks for any ideas.