I'm developing a replacement operational database for gathering plant performance both operational and environmental.

I'm having a problem getting the various tables to have the proper relationship so I can generate reports from them later.

Currently all data is entered through one form. They enter the date, the data for each boiler and then the electrical generation data.

The form then dumps the data in three tables. Each table has the hour and date of the data and the the data for the respective boiler or the generational data.

When I go to generate a report of monthly data, the relationship between the tables is tripping up Access. I tried making a relationship between the date and time of each table, but that hasn't worked so far.

How should I design the database to make work best? Thanks!

Hi

If you can upload a zipped copy of your Database we can take a look and hopefully give you a solution to your problem.

Regards

Mike

The file is attached. I have recreated the queries along the lines of what I'm looking for with concern to a monthly report. I then was planning on making a report off the three queries.

Thanks in advance for any help you can give me!