Changing the Numerical Display Part 2

[Thompyt]

June7,


You provided the following Code:
Using a DLookup():

IsCRNumComplete: DLookup("Action_Complete", "[Change Request]", "CR_No = " & [CR_No] & " AND Sub_No=0")

MYAlias: IIf([IsCRNumComplete] And [sub_no]<>0,[CR_No] & Trim([CR_Numbers]),[CR_Numbers])

It does work for the most part, but always leaves the Action_Complete CR's to a ##.## format.

Is there a way to only have the CR's with CR_No + Sub_No<>0 and Action_Complete=False <> CR_No + Sub_No=0 and Action_Complete=True

I am thinking this derives from the Dlookup code somehow. The current code makes a -1 output for the whole CR if any part of the CR is closed, regardless if there is one part of the CR + Sub_No<>0 is open.

[Thompyt]

Disreguard Problem solved.
I changed
MYAlias: IIf([IsCRNumComplete] And [sub_no]<>0,[CR_No] & Trim([CR_Numbers]),[CR_Numbers])
To
CR_Numbers: IIf([IsComp] And [sub_no]<>0 And [Action_Complete]=False,[CR_No] & Trim([CR_Numberz]),[CR_Numberz])