LOOKUP on a Query, not an update Query

[myhnews]

I used the VLOOKUP in excel. I would like to use the same idea in Access.
Table 1 = MyFirstTable
Field1 = ItmeName
Field2 = Quantity

Table 2 = MySecondTable
Field1 = ItmeName
Field2 = Quantity

I have a query name qMyFirstTable

I would like to add a column in this query that looks in MyFirstTable and returns the Quantity for each item. If it can not find an item, it should return an “X”

If an update query is faster, I will go for an update query.

Thank you
Joe

 

[FoFa]

You can do that with just a std query (and an IIF).
How ever if you must slow it down a little, try using DLOOKUP (about like Excels VLOOKUP). Use Help in domain aggregate functions.