Help with DLOOKUP

[skooterboy]

Hi All,

I'm still learning the some formulation in Access (my head is still stuck in Excel mode).

I'm tyring to use the DLOOKUP function (my understanding is this works similar to VLOOKUP in Excel), but I'm having difficulty understanding it.

I have two tables, and I wish to run a query that will do the following:
Table: PC96_IW_Info_Table
contains a field called "Sku"
contains every product sku in my assortment

Table: Pull_Inventory_Table
also contains a field called "Sku" and a field called "Qyt_On_Hand".
conains only product sku's that have an inventory 'on-hand' quantity

Query
I'd like to run a query that examines the 'Sku' field in PC96_IW_Info_Table and compare that sku to the 'Sku' field in the Pull_Inventory_Table. If it finds a matching sku in the Pull_Inventory_Table, then bring the value in the 'Qyt_On_Hand' field from that Pull_Inventory_Table.

The result should give me an entire list of all my product sku's, and any oh-hand quantities found.

I'm just building an Expression in the query design. I'm hoping someone can help me build this.

Thanks, just all to pieces

 

[pbaldy]

You don't want a DLookup, you want to include both tables in your query with a join between them on the sku field. In your case, you want to edit the join so it includes all records from the info table.