Hi Crystal
Great video with a good example of Cartesian result sets. Where can we get your code? Did you upload a sample DB?
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile/Bill.Mosca
--- In MS_Access_Professionals@yahoogroups.com, Crystal <strive4peace2008@...> wrote:
>
>
> Last week was VLOOKUP Week! ... a tradition started by Bill "MrExcel" Jelen, who has a YouTube channel called BJELE123 with great videos for learning Excel. When Bill asked me to do a VLOOKUP video, I was honored as I usually make videos for Access and Windows Phone development. It was fun!
>
> This video calculates distance between coordinates using VLOOKUP to get Latitude and Longitude from a table of Zip Codes, which is available as a free download on my website.
>
> There is also Concatenation, Errors (of course) and how to fix them, Relative and Absolute References, Range Names, Transposing, VBA, Table Styles, Formatting, and Conditional Formatting.
>
> Excel VLOOKUP to Calculate Distances using Latitude & Longitude, by Crystal (cc) VLOOKUP Week
> http://www.youtube.com/watch?v=bc92JR2OPss&feature=BFa&list=PL7C75A052F80E19B7
>
> Now, we build the same thing in 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, change Colors based on Row.
>
> Convert VLOOKUP equations to Access, by Crystal for VLOOKUP Week
> http://www.youtube.com/watch?v=ED_Wd4w9PLk&feature=BFa&list=PL7C75A052F80E19B7
>
>
> Warm Regards,
> Crystal
>
> *
> (: have an awesome day :)
> *
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar