|
||||||
|
Job History By Richard Rost ![]() ![]() Display Recent Job History for Candidates in Access In this Microsoft Access tutorial, I'll show you how to display a candidate's most recent job and the one prior, without having to sort through their entire job history. This technique will involve using key functions such as DLookup, DMax, and NZ, without any programming. Evan from Allen, Texas (a Platinum Member) asks: I run an employment agency and maintain a complete job history for each of our candidates. When viewing a candidate's record, it would be helpful to quickly see their current job and the most recent previous job at a glance. What is the best way to display this information on their record? MembersThere is no extended cut, but here is the file download: Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today! Prerequisites
LinksRecommended CoursesUp Next
Keywords
TechHelp Access, recent job history, candidate job display, job history query, DLookup function, DMax function, continuous forms, table relationships, current job identification, TechHelp template, employment agency database, customer-job link, non-programmatic database solutions, job comparison
|
||||||||||||||||||||||||
| |||
Keywords: TechHelp Access, recent job history, candidate job display, job history query, DLookup function, DMax function, continuous forms, table relationships, current job identification, TechHelp template, employment agency database, customer-job link, non-progra PermaLink Job History in Microsoft Access |