Convert Excel VLOOKUP equations to Access
Channel: LearnAccessByCrystal
Date: 02/04/2012

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/forum/getdistance-function-for-latitudes-and-longitudes_topic604.html

Bill Jelen's YouTube channel:
http://www.YouTube.com/bjele123

My Reference Database
http://www.accessmvp.com/strive4peace/Reference.htm

Learn VBA
http://www.accessmvp.com/strive4peace/VBA.htm

Call to Excel Gurus: VLOOKUP Week
http://vlookupweek.wordpress.com/excel-gurus/

Switch from tabs to overlapping windows (2007)
http://office.microsoft.com/en-us/access/HA012292811033.aspx

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 ~