Beginner needs help with Access

[darkwolf45]

Good morning,
I have a database, with several tables that I import from other sources. The two main tables have identical fields, however, the data in them differs in the fact that one is Dollars and the other is hours. Both tables have the following columns:
Cost Ctr
Cost Ctr Description
Account
Account Description
Year-to-date
Current Period

For each year there would be two tables like described above (very large, the table with dollars is almost 104,000 rows)

The next table allows me to map the first table according to my needs:
MC Line
Cost Center
Cost Center Description

Finally, I have another table that allows me to categorize data:
Account
Account Type

Right now, I'm trying to keep my scope of how I use this database rather modest. All I want right now is to be able to put dollars and hours side by side. This is difficult because both tables have items that don't have a matching value in the other table (i.e. hourly accruals that there are no dollars for or salries paid that there are no hours for). My attempts at querying haven't met with any success in returning all records.

The other option I came up with was to simply rename one of the fields in the hours table, add a like named column to the dollars table and simply append the hours table to the dollars table. This seems like a waste, however, as there are many duplicate records that have either nothin in the hours column or nothing in the dollars column.

Could anyone give me some insight into how to better set up this database?

 

[darkwolf45]

Watch out of for datatypes in the tables (perhaps in the temp table). It should be Number Double or Currency, not Number Long Integer.

You seem to be right, that fixed the problem. Thanks!