I am trying to develop a db originally written by someone else that has a series of fields in tblOperatorReports labeled RawPartNumber1, RawPartNumber2, etc... to RawPartNumber 14. In the form they present themselves as a single column though in truth they are 14 separate columns. Now however, the client wants to be able to search/report based on the contents of that "field/column". I have tried several things to solve the problem but in each case the solution was not workable and I have had no success... I have some experience w/ the object oriented aspects but not great at sql or vba and have come to a brick wall in terms of options to overcome this problem. Any assistance would be GREATLY appreciated.
Respects and Regards,
Chris