Recent content by msasteel

The purpose of the category field is to track our costs for each of the categories.

Also, each part will only have on category. The descriptions are simple enough that I can determine the right category.

The overall picture: I am given a list of parts from Engineering with descriptions - hundreds for one project. I need to go through each part and categorize each part as MECHANICAL, ELECTRICAL, PNEUMATIC, PLUMBING, or DOCUMENT. This information is used for spare parts reports for our service...

The problem there is that I need to write the appropriate category (ELECTRICAL or MECHANICAL) into the field in the main parts table. If I use Instr then I have to translate the 1 or 0 so it can represent the correct category. Am I missing something here?

Hello! I hope someone can help me! I have a database with hundreds of records in a main table called tblPARTS which has three fields - Part Number, Part Description and Category. I have another table, tblKEYWORDS, with two fields; a field called KEYWORDS which has words like "cable"...

Hello! So sorry... I posted my question here and should not have. I am an intermediate user of ACCESS and am really interested in learning as much as I can. thank you for being there!!