We have user defined fields in an equipment table. They could be Alpha,  Date or Amt. We created a new Alpha field in the software program for equipment xref numbers.

 

I have a table with 6 fields that store the user defined info.

 

Company

Equipment

UserDefinedSequence

Alpha_Field

Date_Field

Amount_Field

 

The field called "UserDefinedSequence" stores an ID number for the users defined fields. "Alpha_Field" holds the  xref number we are trying to get.

 

Right now we are using 2 user defined Alpha fields in the software so there is 2 codes in the UserDefinedSequence field (000018 and 000070).

 

The info is stored in the Alpha_Field.

 

When I run the report for Equipement # 1000... I get

 

EQ#        Seq#        XREF#

 

1000       000018

1000       000070    3056

 

Here is my formula:

 

whileprintingrecords;
iif ({EC_EQP_USER_DEF_FLDS_MC.User_Def_Sequence}="000070",{EC_EQP_USER_DEF_FLDS_MC.Alpha_Field},"")

 

I need the formula to return just on row showing a xref # if it has one or not.

 

thanks

 

Rick

 

 

 

 

when I do all I get are those records with a XREF#. I need to see if it is blank also, not having a XREF#.

 

 

Rick

 

 

is this 2 options?

 

does the formula go into a field or go into Select Expert?

 

 

 

thanks

 

Rick

 

in select expert which field does this formula apply to? Userdef or Alpha field?

 

Also when I did this formula, the Record select split it into to entries.

 

 

 

I get no results.

 

 

Rick