Hi sir,
I am interested in your project and offer my services.
I am a skilled Access, VBA and SQL developer and can give you exact solution you want, I hope.
I have done this before and I can give you solution that you'll be able to search in multiple tables, including strings, dates and numbers. You'll also be able to select comparison parameters like it should be equal to, not equal to, start from or even if contains your search string in anywhere in tables.
Let me know if you have further details.
Looking forward,
Nblsoft