Query with Vlookup formula

[mari_hitz]

Hi everyone,

I am new with access and I would like to make a question to see if it is possible to create a query that contains the a formula similar to the vlookup formula in excel.
I have to create a data base with three different tables that include different information from the same people, so then I would like to create a query to see if the same people is included effectively in the others tables or not. If I have to do this excel I would use the vlookup, however I need to do this in acess because based on this information there will be several actions to take from that point. It is possible to do this?

Thanks!

 

[pbaldy]

Well, the nearest match to VLookup in Excel is probably DLookup in Access. That said, you might clarify or give an example of what you're trying to achieve. Normally a query uses joins to get related data from different tables, and joins are much more efficient than domain aggregate functions (of which DLookup is one).

 

[mari_hitz]

Thanks Pbaldy!

What I am trying to do is the following: I have three different reports that contain information 1, information 2 and information 3. I would like to use the vlook up to know which persons from the report 1 is in the report 2 and 3. That is why I need to know if this is possible in access, because I tought that with some query I might be able to get this information.

Thanks!

 

[pbaldy]

Can you post a sample db here that shows how the data is laid out, with the result you want to see?

 

[mari_hitz]

Hi Thanks for your help! What I am trying to do is the following: based on my example database, where I have created two tables I would like to create a query that based on the information on table one, bring me certain information that it is not allocated in the Table 1, but it is on Table 2 for example "Office". I have tried to make a Dlookup but I had not sucess. I do not know if what I am trying to do is possible. Please let me know. Thanks!


Database4.accdb - 280 KB

 

[pbaldy]

I'm not the brightest bulb on the tree, but it doesn't appear there are any tables in that db. Am I missing something? If you post another, can you post it here rather than a separate website?

 

[mari_hitz]

Thanks! I had uploaded the wrong file indeed.
I have uploaded now a file with two tables. There are several persons that are not included in both tables, and the information that each table contains is different.
I would like to have a query, similar to the Vlookup, that can compare table 1 againts table 2 and tell me which persons are included in both tables and give me the information included in table 2 that it is not included in table 1 for that people that is is included in both tables.

I do not know if I have expressed myself good.

Thanks in advance!