hi all,
i've looked over sevaral forums an used google but could not find the awnser hope you can help!
for my report i use sevaral summeries. one of the sumery outcome is an indexnumber of one of mij DB tables.
example:
tablex
index articleshort dscr article lang discr
1 xy xyza
2 sm abcf
the summery outcome is 2 now i want to lookup the long discription wicht belongs to index nr 2 the summery is something like NthSmallest (1, {Orderinformatie.Prijs per eenheid})
how can i create a function that looks up the article lang discr based on the summery fiels nthsmallest where nthsmallest = index
i need this on my report footer where a written summery will be placed including the outcome of these functions
again hope someone can help, and read my poor englisch
Edited by bierlaagh - 23 Mar 2011 at 9:41am
IP Logged
