I have a query where field 1 is grouped by Exch_Name and where the Exch_Name field is taken from query [Time - Data].
Field 2 uses this IIF expression:
IIf([TIME - DATA!Exch_Name]=[TIME 00-01 COUNT]![Exch_Name],[TIME 00-01 COUNT]![CountOfExch_Name],"0")
My goal is to keep the group of Exch_Name the same in field 1 no matter what and for field 2 to populate only if there is a number present from [Time 00-01 Count].
The result right now is this:
Name-1 | 0
Name-2 | 0
Name-2 | 1
Name-3 | 0
Because it found a number for Name-2 from [TIME 00-01 COUNT]![CountOfExch_Name] it added another Name-2 below the original group listing from field 1 and put the counts. How can I get the expression to not repeat if it found a number?