vlookup

[eran185]

hi
in excel there is the function - vlookup.
i need to do something like vlookup in the att. file
1-i want to see the details of the car when i give the id
2- i want to see the details of the car in a summarizing table that contain all the details

 

[odin1701]

http://allenbrowne.com/ser-42.html

Read through that, I beleive that might be something that would help.

DLookup is I think what you're looking for, but ELookup can be better.

 

[neileg]

What you need is a select query that takes both tables and joins them on [number plate].

 

[eran185]

i'm "fresh" in access - could u explain me how can i do this thing ??

 

[neileg]

Open the queries view in the database window and use the query wizard. Post back here with any problems.

 

[eran185]

problem - vlookup

hi
i build the query , but the problem is that i saw only the lines that has same id.
i want to see also the cars that not match (like in the excel , to get #name)

what can i do ?

 

[neileg]

When you join two tables in Access, it defaults to an inner join (type 1 join in Access terms). This, as you have found, returns data only when there are matching records on both sides. If you right click the join line in the query you have the choice of join types. The other two options are left (number 2) and right (number 3). Depneding on which way round your tables are positioned, chose the correct one of these to give you all the data from one table and the data from the other table that matches.