I have finally come closer to my goal! It has taken a few steps, but I'm getting there. First, I have created four make table queries, breaking down the part numbers. The first is for the purchase report, the second for all '-C' parts, the third for all '-ISA' parts, and the fourth for all...
Thanks to BigGoober and Robertd for their replies. Yes, I did try using the '&' in the left statement. No positive results. I have been able to break the problem down somewhat using queries sorting on the part number extensions, i.e. LIKE "*-C". I've had limited success taking this...
Hi all. I hope that I can explain this problem clearly so that I may be understood, so please bear with me.
I am trying to build a query that will match data from one table to data of another table with an extension added to the number. At my company we must generate a report each week for...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.