Relationships and reporting using dates

[Fear No Evil]

Hi all. I am really rusty at Access. I bet I used to know how to do this,
but for now, the skill is gone.

I have a db with 4 tables, Demonstrations, Expenses, Receipts, and Mileage.
I want to create a report that allows me to pull up all these info for any
given day or date range.

I already know how to make a query for *each table* that pulls up by date.
What I cannot seem to do is create the query that doesn't repeat records
over and over. Example is that all tables are linked by date. The
demonstration table is the boss table if that means anything. There can be
many demos on any day along with many expenses and receipts on any day. So
a query using multiple tables ends up with rows from the expense table
repeating them selves.

As a workaround, I drag and dropped each separate query onto the report
design area. Now I have to enter the same date four times into four
separate dialog boxes to get a coherent set of results.

Thanks for reading. Thanks in advance for any insights or places to study.

Phil

 

[Duane Hookom]

You will need to use subreports. If all the tables are linked by date and
you want to display information from each of the tables, create your main
report based only on a query with each unique date. Then use four subreports
in the detail section of the main report. These subreports will use the Link
Master/Child properties to filter the subreport records to only the one
date.