query based on different devices

  • Thread starter Thread starter Nick A Carter
  • Start date Start date
N

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?
 
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
 
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)
 
Back
Top