Forum Discussion
MS Access: Looking to find a way to check for matches across two fields based on character position.
Apologies for the long involved title. I'm super rusty and don't remember all the exact correct jargon. I have a database with 30 or so fields. One of those fields is just a simple Fiscal Year fie...
iif(right([the FY field name],2) = mid([the ID field name],8,2),"MATCHED","NOT MATCHED")
If opportunity presents, either change the data model so that each concept occupies one field (ie CompanyLocation, ProjectType, ProjectYear and so on), or failing that, use queries that split the complex fields into their 'atomic' bits (CompanyLocation etc) and always use those queries when accessing the data. This might be informative: https://www.techtarget.com/whatis/definition/data-abstraction
If opportunity presents, either change the data model so that each concept occupies one field (ie CompanyLocation, ProjectType, ProjectYear and so on), or failing that, use queries that split the complex fields into their 'atomic' bits (CompanyLocation etc) and always use those queries when accessing the data. This might be informative: https://www.techtarget.com/whatis/definition/data-abstraction
