Prev
Next
Forums User Experience Lawson Add-Ins for Microsoft Office

Lawson Query Wizard - How to return max value only

 0 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages


JohnHoward











New Member



Posts: 1




New Member



8/15/2016 5:32 PM
    I'm new to Lawson and the Query tool, which is all I have to work with.  I'm trying to query the HRHISTORY table and only return the max value of BEG_DATE for Field number 20 for each employee.  Is there a way to do this?  I've used the subtotals but I don't want to return every row of data.