Forums
Lawson Add-Ins for Microsoft Office
Lawson Query Wizard - How to return max value only
Author
Messages
JohnHoward
New Member
Posts: 1
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.