Vlookup in Access?

[Sgligori]

I have a table called "Do Not Sell" with a list of items that should not be sold. I have another table called "Sales" that show all the sales for the month. How can I reference the "Do Not Sell" table to pull over a "Y" or "N" value for each item sold (if the item is on the "Do Not Sell" table, I want it to be flagged "Y"). In Excel, I would simply do a vlookup to determine whether the item is on the "Do Not Sell" list. I'm not sure how this is done in Access. I've heard about Dlookups as the Access-alternative, but I don't know how to apply it to my specific case. Any help would be much appreciated! Thanks!



Also, I'm not sure whether it's mentioning, but I don't have a primary key. The "Do Not Sell" list is just a table containing one column- the manufacturer codes for the items.

[ItsMe]

If I understand you correctly, you would build a query to find items in the Do Not Sell list that are in the Sales table. It should be as simple as creating a JOIN and adjusting the properties of the join. I would use the Query Designer. You can build a query by clicking the Query Design button from within the Ribbon. It is located under the Create tab.

[Sgligori]

The join query results only show the items from the Sales that are on the Do Not Sell list. I want my updated table to show all the sales WITH the items that are on the Do Not Sell list flagged.

[ItsMe]

Perhaps you can adjust the properties of your JOIN to display all records from table Sales and only those from DoNotSell that have equal values. Double clicking the line that is the JOIN is a shortcut to the properties window.

You can add an alias to your query by typing syntax int the grid. Use a new column in the field row. Maybe an IIf statement is in order. Here is an example of adding an alias with the name NoSaleList
NoSaleList: IIf([tblName].[FieldName]<>"",'Yes','No')

[Sgligori]

It worked! Thank you!

[ItsMe]

You bet...