Convert Excel VLOOKUP equations to Access
In my last VLOOKUP Week video, I showed you how to make a Distance Table using the VLOOKUP function in Excel. Now, we build the same thing in Access -- will show you how to convert VLOOKUP equations to Access :)
Import tables from another database, DLookup, DMin, Query Critera and Calculated fields, VBA, Crosstab, Report Design, Align controls, Change widths, Format numbers, Page Layout, Detail Section, Colors.
~~~~~
LINKS
GetDistance Function for Latitudes and Longitudes
http://www.rogersaccesslibrary.com/fo...
Bill Jelen's YouTube channel:
/ bjele123
My Reference Database
http://www.accessmvp.com/strive4peace...
Learn VBA
http://www.accessmvp.com/strive4peace...
Call to Excel Gurus: VLOOKUP Week
http://vlookupweek.wordpress.com/exce...
Switch from tabs to overlapping windows (2007)
http://office.microsoft.com/en-us/acc...
happy learning!
let's connect *
Do you need help? You know your business. I know how to teach, write programs, and develop applications. If you have a budget and want control of your project, let's connect and build it together!
visit MsAccessGurus and contact me today!
http://msaccessgurus.com
I look forward to hearing from you ~
warm regards,
crystal
Remote Programming & Training -- connect to me, let's built it together
~ have an awesome day ~