Recent content by JKJQW

I need to update a field (field4) so it will get rid of the 0 after the dash. example1 0001-001 example2 222-001-02 The following query works with example1 only. Is the Iif statement the way to go here? I tried it a few different ways without any luck. The desired results are example1 0001-1...

Not sure what a foreign key is. It is not dependent on the part_no. data type is text. there can be many layout_no with respect to one part_no. think of the layout_no as an assembly drawing with many parts. and part_no as a single component part part_no 123 can be in layout_no 456 and 789 and so...

thanks mile Too much water under the bridge to change that stuff now. Any ideas about the second part of my question? jkjqw

I have a database to track part numbers in an engineering dept. The primary key is part_no and one of the fields is called layout_no. I need to set it up so that the same part can be a part in many different layouts. I then need to produce a report based on the layout_no for a bill of materials...

Thanks for responding, Is there any way to get it done without having to put the * in the criteria?

Hi all, I'm trying to set up a search form that runs a query. I have it all worked out except that I need help with the code. I used the sample from the microsoft help desk but I would like to modify it so that the user can type just a portion of customer id can be used as criteria. As it is...