Make new table from others.

[timecreature]

I need help, i am completely new to access but know a little bit on excel.
I have three tables in access.
I would like to be able to create a report or table using data pulled from the other tables.

In table 2 i have 4 columns. The ID field, Grp1, Grp2 and description.
Grp 1 is numeric as is Grp 2. Description is text.

Grp 1 is used like a parent and Grp 2 children with description explaining what it is.

In the third table i have Grp 1 and Grp 2 but not the description so i would like to be able to add the description to the table.

These things are difficult to explain.

 

[spikepl]

What you need is a little bit of effort. Find an access table, then query then form tutorial and spend the entire 2 hous that takes. Then most of your concerns will be answered. If not. find a template and see how it is set up. You have heard of google, I presume.

 

[timecreature]

Thanks for that Spike and for the tip about google.
Apparently its a search engine! who knew?

I used it to look you up and it came back troll.

Please jog on.

 

[CJ_London]

if you can't explain, show - provide some examples of the contents of your 3 tables and the result you want.

tip - use your actual table and field names.

 

[timecreature]

I will try to explain using a car analogy.
Say table 1 is a list of cars by make model and colour and table 2 is a list of jobs on the cars but this table contains only make and model and not colour i would like to be able to display the colour on table 2.
Table 1
Make Model Colour
Ford Fiesta Silver
Ford Focus Blue

Table 2
Job Make Model Colour Start Date
Service Ford Fiesta (would like this to pulled from table 1) 01/04/2013
Tyres Ford Focus (this should be colour blue) 01/04/2013

So in table 2 on my database. i have 278 tasks broken down into 39 groups. The biggest group having 52 tasks detailed within.
On my table 2 i have a list like 29 in one field and 1 in another and 12 in one field 2 in another which relate to MAGNETIC AGITATOR MAINTENANCE and CALIBRATE TEMPERATURE INDICATOR
I just wondered if it was possible to pull the info into one sheet.

In excel i have managed to do this for a unique number that relates to a maintenance plan using vlookup and copying from one worksheet into another but this one needs to evaluate the number in field 1 then field 2 then pull the figure from field 3 into another table/query/report.

I do take your point Spike and i have tried to seek self help. There seems to be less information on youtube for access.

I have set up relationships and run a query and get mismatched expression, i think its because it less of ones isnt unique but i am sure that this problem can be solved. I just dont know how.

Apologies for the long post.

 

[CJ_London]

Thank you for providing the data. Unfortunately it is not what I asked for, so I cannot provide a solution.

As Spike suggests, do a tutorial so that you can get the terminology right and learn about good database design. You may be doing it but I can't see it from what you describe.

 

[timecreature]

May i offer you a little thanks for your help.