Information from different tables in one query

[jammy_owen]

hi all, i've come across a minor problem here involving access.

basically, i've got different tables that have some of the fields the same i.e title, date, price etc. but it would really help if i could merge the information so i could see it present in one table, and i'm only guessing that query will be able to accomplish this task (with he help of you lot of course!)

any help will be great. thanx!

PS by 'merge the information' i don't mean simply have the different fields in one query where the fileds would be 'title', 'title', 'date', 'date' etc. but rather 'title' from all of the relevant tables in the SAME field and ditto for the 'date' etc.

 

[FoFa]

You can create a query (view) to use for this. You just need to join the tables on some key field, and select which ones you want to display.

Tbl1
T1Key, T1Title, T1Name

Tbl2
T2key, T1Key, T2Title, T2Name, T2Phone

SELECT T1Title as Title, T2Name as Name, T2Phonce as Phone FROM Tbl1 INNER JOIN Tbl2 on Tbl1.T1Key = Tbl2.T1Key

would pull Title from Tbl1, Name and Phone from Tbl2 for thlose records that match on the keys. You can then use this query as the basis for other things, like reports, queries.