Text calculation not giving desired results.

[Steve G]

I've got a table with a number of fields, among them "User", "Model", "Type", and "User with Model". (All fields are text fields.) The contents are pretty obvious; "User" is the username, "Model" is the manufacturer and model information for that hardware, and "Type" is the type of hardware (mouse, laptop, etc). The "User with Model" field auto-enters a calculated value thus:

If ( (Type = "Workstation") or (Type = "Server") or (Type = "Laptop") ; User & " (" & Manf Model & ")" ; "" )

This generally works fine. In records where the hardware is a Workstation, Server or Laptop, I get the appropriately generated field ("john_doe (Apple iMac)", etc). In records where the hardware is NOT a Workstation, Server or Laptop, the field is left blank.

The problem arises when the "Type" field is left blank in a record. When this happens I get "john_doe ()".

How to fix?

[mr_vodka]

It should be working. Please post a copy of your file perhaps with only one record.

[Steve G]

I managed a workaround by adding a condition:

If ( (Type ≠ "") and ((Type = "Workstation") or (Type = "Server") or (Type = "Laptop")) ) ; User & " (" & Manf Model & ")" ; "" )

Edited September 29, 2008 by Guest