Question How to do a vlookup in access

[Jacquilov]

I have created 2 tables in access and I am trying to find the Ship IDs in the 2nd table that are not in the 1st table. How can I do a vlookup to pull the data I need.

 

[Galaxiom]

Use a query with a join between the two tables on ShipID.
Set the join properties to "Show all records in the 2nd table and mathcing records in the first table".

Set the criteria for the ShipID in the first table to Is Null.

 

[vbaInet]

You would need a query for this. The closest equivalent is a DLookup() function but that will only return the first occurence.

The following steps assumes that there is a relationship between both tables.

1. Using the Query Wizard, include the IDs from both tables.
2. Right-click the join and select the option to INCLUDE ALL RECORDS FROM TABLE 2
3. Under the criteria row of Table 1's ID field put this Is Null

Welcome to AWF by the way
Edit: GalaxiomAtHome got here before me.

 

[Jacquilov]

Thanks for your input.

 

[dkinley]

Here is a simulated VLookup done in Access by persons much smarter than I.

-dK

 

[gemma-the-husky]

note that what you are looking for may be found by an unmatched query - which the query builder wizard can help you with.

 

[Trevor G]

Welcome to the Forum,

You can create your own thread as this isn't related to this thread.

What you need to do is use an UPDATE QUERY. Here is an example on YouTube which will demonstrate how to use the UPDATE QUERY

http://www.youtube.com/watch?v=d8pbgEh2-QI

 

[rob1]

ok ive created a thread of my own, ive watched the video, i still dont properly understand. Is it possible for it to sort of "autofill" the field with the data, in a form screen?