I recently moved from Excel 2007 to Access 2007 to manage what never should have been spreadsheets. Unfortunately, from what I can tell, the LOOKUP function in Excel does not exactly work the same as a Lookup column in Access.
My difficulty with Access lies in translating the functionality from an Excel a LOOKUP that may have looked like this:
=LOOKUP(A47, Winning!A1:A112, Winning!B1:B112)
I am having trouble building an expression that captures this functionality. In searching for an explanation on how to populate one column using data entered from a previous one, I have found various methods involving filters and VBA, but no explanation of how they work and I am reluctant to simply drop in code if I don't have much of an explanation of how it works.
- How do I populate one column using the input from a previous one?
- Is there a way to do so using relationships, or is an expression a better method?
- I am expecting to be entering either an expression into a selection filter that selects based on the input column, or something akin to DATE() where a default value is dropped based on COLUMNNAME([FILTER]); are there integrity issues with this approach?
DLookupbe a more effective tool here? Something like;
DLookup([CCD].[Name], [CCDBackend], [CCD].[ClientID]=[CCDBackend].[ClientID])
- Is there a resource available for the Excel-addled brain trying to reforge itself in some Access accessible way?
I'm trying not clog up the question queue with inane iterations of VBA gobbledygook. Please bear in mind that for this question explanations of answers and methods will be more helpful than a code snippet.