Almost,

Out of the 31 records returned, 4 have a BatchNo > 0, but none
of the records show the Used_By.



>>I have the following query:
>>
>>

>>SELECT Id, EntryDate, TranDate, BatchId, EntityId, Count(*) AS Cnt, BatchNo;
>>  FROM Resh;
>>  WHERE Resh.Status == " ";
>>  GROUP BY Resh.BatchId;
>>  ORDER BY BatchId;
>>  INTO CURSOR Temp1
>>

>>
>>
>>Some batches may be in use by other users. It's possible for a batch
>>to be used by multiple users. When a batch is in use, the BatchNo field
>>will not be zero.
>>
>>I want to show the user names of the users who have the batch open. The
>>User field is "Used_By".
>>
>>Thanks
>
>
>
>

>SELECT Id, EntryDate, TranDate, BatchId, EntityId, Count(*) AS Cnt, BatchNo,;
>  IIF(Empty(BatchNo),SPACE(Len(Used_By)),Used_By) AS Used_By;
>  FROM Resh;
>  WHERE Resh.Status == " ";
>  GROUP BY Resh.BatchId;
>  ORDER BY BatchId;
>  INTO CURSOR Temp1
>

>
>Is that enough?