How to write exel funtion in access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I could not figure it out on how to write VLOOKUP funtion in access.
 
Normally the equivalent in Access is the DLookup function, but more details
of what you're trying to do would help.
 
Hi John -- Are you trying to use the actual VLookup function in Access or
just trying to mimic the functionality? What are you trying to do exactly?
 
I guess, I am trying to mimic the fuction so that it will work in access.
Just wondering if we can use the actual Vlookup function in Access.
 
I am just trying to do all my work in access instead of exporting the file to
exel and do the Vlookup. Just wondering if I can do the same thing in access.
 
As Douglas mentioned, the DLookup function can provide similar functionality.
You can, however, use the actual VLookup function using VBA and an Excel
object but it's probably more trouble then it is worth.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert Access database into a proper application 2
Default Value Function for Modify_Date Field 3
CONVERT function for Excel 2003 2
Asterisk next to a Sendkeys function in a macro 0
Function Problem 2
in access databse the function date() returns #name 2
Writing Multiple IIF Function 3
I would like my database on exit to make a copy or replicate 1

Back
Top