Windows 7 
Access 2007
We get reports in from a source that gives us the company name. I link them up with our table that has the customer name and than I start by taking the first 13 characters from the source report and the first 13 from our table and than I move down to 12 and where the ID is null and I keep doing this until I get down to the first 5 characters in a query. I built a query that does this and currently have the user enter the 13..... until they get to five and that way we get 90% of the ID's that I Need. I was thinking of building 9 queries to do this but it seems redundant. Any other thoughts out there?
Reply With Quote
