need help w/ report sugguestions? urgent!

[Cam]

Hello,

I am just created all the tables for tracking daily production activities,
such as passdown from 1st to 3rd shift assembler, machine issue, manpower
issue, etc..
They are all in a seperate table with entry date field in each table. Most
of the field in all tables are different except maybe 3 max.

Now, I ran into a problem creating reports where I couldn't ties all the
tables together by date. For reports, I want to be able to filter the date
range for the reports and it will shows all the activties (tables) occuring
during the date specified in one report.

Don't know what to do. Do I need to combine all the tables into one or is
there a way to tie all the table to a date field? Thanks for any sugguestion.

 

[Duane Hookom]

I don't know why you don't have all of the notes in one table. If you can't
combine them into a single table, you might be able to use a union query to
combine them so they look like a single table.