Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jul 2001
    Location
    SF, CA
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel Vlookup Equivalent in Access? (2000)

    Hi,

    I'm VERY new to Access.

    For reports/forms, is there an Access expression similar to an Excel vlookup formula?

    Let me know if I need to provide more details.

    Thanks!

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Excel Vlookup Equivalent in Access? (2000)

    Not exactly. In Access, you can use the DLookup function to retrieve a value from a table, but what you usually do is bind a form or report to a table or query and populate fields from that automatically. Queries are usually the best method of returning data, since you can join multiple tables in a single query to populate your form or report, plus you can use comboboxes and listboxes that get their rows from still another table or query.

    If you explain more about what you're trying to do, I'm sure someone will be able to help you.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •