If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
query based on different devices
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? |
#3
|
|||
|
|||
query based on different devices
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) -- KARL DEWEY Build a little - Test a little "Nick A Carter" wrote: 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? |
Thread Tools | |
Display Modes | |
|
|