I need help

[helpmequery]

This may not be in the right forum and I am sorry about that.

I have 4 tables that I need to merge and create a report out of.

I have 1 current Electric Table and 1 historic Electric Table 1 currect Gas table 1 historic Gas table. They are all connected by Property. They all have a usage, cost and month field. The tables all kinda looks like this:

Month Property Usage Cost
Dec Place1 2 3.5
Jan Place1 3 4
Feb Place1 2 3
Dec Place2 2 3.5
Jan Place2 3 4
Feb Place2 2 3

I need to combine the 4 tables to look like this:
Dec04 Dec05
Electric Use
Nat Gas Use
Elec Cost
Gas Cost

Any suggestions? Thank you I am going crazy over this!!!

 

[dfwcomputer]

May help if you lay out the actual tables so we can see.

e.g


Table1
ID
Field

or go to relationships window and press Alt & Print/Scrn and press Control V to paste it into your favourite photo editing program and post it on here.

Dean