Thanks for the responses.
I believe the DMAX and DMIN would provide the MAX and MIN Values but
not the values in between unless one could figure a slick query that
eliminates the first level of DMAX and DMIN. Perhaps I need a DNEXT()
Function!!
I am aware of the fConcatChild() function, but now that you've
mentioned it I'll need a function to parse the values of the resulting
string to get them into the proper location in the query grid. I
should be able to come up with something. I'll let you know.
Regards
On Jun 8, 5:43 pm, Bob Quintal <rquin...@sPAmpatico.cawrote:
Ed Marzan <ducojan...@aol.comwrote innews:11**********************@e65g2000hsc.google groups.com:
Greetings,
I have a query that returns varying prices for the same item
in the following manner.
Item1 Price1
Item1 Price2
Item1 Price3
Item1 Price4
Item2 Price1
Item2 Price2
Item2 Price3
Item2 Price4
How can I get the query to display as
Item1 Price1 Price2 Price3 Price4
Item2 Price1 Price2 Price3 Price4
I tried the crosstab without success as there too many
different prices. I can use DMAX and DMIN for the highest and
lowest values but how do I get the values in between?
Thanks!
use the function fConcatenateChild() that you can find at many
places on the web.
--
Bob Quintal