PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 08/15/2016 1:32 PM by  JohnHoward
Lawson Query Wizard - How to return max value only
 0 Replies
Sort:
You are not authorized to post a reply.
Author Messages
JohnHoward
HR Analyst
Private
New Member
(1 points)
New Member
Posts:1


Send Message:

--
08/15/2016 1: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.
    You are not authorized to post a reply.