Vlookup

  • Thread starter Thread starter Maxwell
  • Start date Start date
M

Maxwell

How does one do a vlookup in Access?

How does it work?

can you do a vlookup in Tables, Queries, Forms, Reports?

Can you give me an example of how one maight write this
formula? I know some formulas in Access are different
from Excel such as the IIF vs. IF statment.
 
For an exact match?

You just simply put your values into a table.

To retrieve one value, you can use dlookup

So, if we have some part numbers, and we need the part description, then you
can use dlookup in a form.

If you are using a report, then using the query builder makes the need for
lookup obsolete, as you can just drop in the other table, and do a join.

So, or a text box, you can use:

=dlookup("field value to grab","the table name","the condtion")

=dlookup("PartDescription","tblParts","partnum = 123")

The above would lookup the pardescription text from table parts, and the
partnum is 123

If the partnumber was a field on the form, then you could use:

=dlookup("PartDescription","tblParts","partnum = " & [partnum])
 
Back
Top