Merging 2 tables together

[Mustakrakish]

Hi everybody,

I am new to access and I have a bit problem

I have 2 tables with products. One is products actualy produced and second is products planned in budget. 80% of products are same, but there can be products which have not been produced yet, or which have been produced but not planned in budget.

Now i need to put these 2 tables together, best would be query, because table with actuals is updated every month, so I can compare budget with actuals

I use access 2010

I have been working with it like 2-3 weeks, so i need very simple solution. I have been programming in VBA in Excel, but not yet in access.

Thanks for help

 

[spikepl]

Keeping similar data in separate tables, just because some single data attribute differs, is contrary to normalization, and should be done only if there is some very specific reason for it. Google database normalization.

If you do have some good specific reason, then you can access similar data from more than one table using UNION query : http://office.microsoft.com/en-us/a...eries-by-using-a-union-query-HA010206109.aspx

 

[Mustakrakish]

Thx for suggestion.

I can not keep actual and budgeted values in 1 table.

1. Actual table is updated every month from excel source.

2. Budget is given will not be changin and can not be changed.

My problem is that I have 3 types of products:

I. Which are only in Budget
II. Are only in Actuals
III. Are in both tables.

Now I used UNION query just to put together all products, I will see if I can add values and criteria into it to make report which i need This is the first time i see SQL

 

[spikepl]

Don't worry too much. Many people saw SQL for the first time in their lives, and yet suvived the experience.