Report from 2 differnt tables

[Scott]

I may be overlookingn something simple but here is my problem,

I have two tables

one contains accounts data on money spent on parts for machines

the other contains how many hours each machine has worked in every month (ie
listed month by month)

I have a report that lists the parts bought and cost which is grouped by
machine, machine type, and location.

I need to list how much time the machinery has been working between the
times parts are bought from it.

ie i need to pic out hours worked between dates from acounts data, for each
machine by machine type, and location.

so far no luck.

 

[Golfinray]

I would start by building a query with the two tables. Pull into the query
all data you will need for the report. Filter your query for the dates you
want.

 

[Scott]

The only problem with that is that the dates I need to filter by are the min
and max of each group of records.
i.e. say there are 4 records for one part for one machine, i want to get the
time between the first and the last so i can see how many hours the machine
has worked in that period of time.