I have a colleague's spreadsheet that I need to model in database and I have been away from Access for quite some time. There are a series of tableted filtering conditions that I need to implement in an elegant way without hard coding them into the SQL of queries. Some are 'begins with', some 'ends with', some 'contains', etc. As well as some eliminating characteristics like 'does not equal', 'does not contain' etc.
As the screenshot shows, the user is using SUMIFS to get his results. Does anyone have an idea how I would build something in Access to handle the filtering? I am thinking that I will need to table the conditions but I am not sure what the simplest way to do that would be.
Thanks and Regards,
Patrick