query based on different devices

[Nick A Carter]

I work in a very large IT database that tracks serverfarm racks and the
equipment on them. We just had a new field added to the database and I need
to populate it. This is based on a relationship of two or more devices.
Below are the fields that I will be working with. The "rack_type" field is
empty and needs to be populated.

manufacture_model function rack row rack_type
DELL switch KMM
DELL rack

Currently I fill out two rows; one for the switch and the other for the
rack, then I search through the results for those that have the same "row"
and "rack" and populate the "rack_type" that way. This is very time
consuming and is prone to errors.

Can you give me any ideas to link this?

 

[Jeff Boyce]

Nick

I'm not entirely clear how you are determining that a row in your existing
table "qualifies"...

Are you saying that the [manufacture_model] field contains the word "rack"
somewhere in it? If so, you could use a query to find all the rows that
have "rack" somewhere in that field by using the following selection
criterion for that field:

Like * & "rack" & *

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[KARL DEWEY]

Backup your database first ----
If your [manufacture_model] field is always formated as shown with rack
information to the right of the field and separated by a spave use the
following calculated field --
Expr1: Right(InStrRev([manufacture_model]) -1)