>Good Morning Cindy...
>Group by works…....thanks....
>The problem was that the part_numbes were not DISTNCT,
>and there were needed values in the same part_number record.
>Example….
>Table1 Value Value
>Part_number 123 25 – (needed value)
>Part_number 123 50 – (needed value)
>
>The problem could be fixed in two ways…
>Way 1….coded extra step and use GROUP BY before running the result query.
>Way 2… in query statement, call a function that gets the DESCRIPTION…example
> SELECT ………….get_desc(arg) AS fld_description…..
Robert - read about LOOKUP() in the Help for getting the description.
>
>Function get_desc
>Parm part_no
>find by part no
>Return fld_description
>
>Thanks all for your help…..
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only