Lawson Query Wizard - How to return max value only

Author
Messages


JohnHoward











New Member



Posts: 1




New Member



    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.
    ---