Search results

Hi @Pat Hartman it was slotting in the criteria that was making me doubt it. Sometimes Access is not that smart when it comes to my assumptions :) @Minty thanks for the Dlookup example I was almost there but your close quote ampersand was the nugget I needed! Thanks again gents!

Thanks guys, bit of a tougher way to arrange a query but got the criteria right now (Where SQL).

Regards to the query method. If you have two columns in the same table that use the helper table, do you have to create two separate queries then to refer to the joins?

Thanks @Minty I got that working in the Query instead of using a DLookup, much neater. If I was to use DLookup on that ColumnCodes table is that approach how to do it using multiple criteria?

Hello all, this one slightly beyond my skills. I was working on an inherited database dump from a legacy platform that is no longer being subscribed to. I can easily rebuild it just linking the relationships up. There was a table used as a helper table to keep many static lists but splits them...

HI I inherited an existing db, I have an excel file with current details that I have imported to an access table. I want to populate the records with the expiry dates of the imported table, the tricky bit is comparing then adding the info. What is the best way to achieve this, do I have to...