When DMAX and DMIN aren't enough...

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!

re: When DMAX and DMIN aren't enough...

SELECT
item_name,
max(price),
min(price)
FROM
QueryYouMentioned

Cheers,
Jason Lepack

On Jun 8, 4:02 pm, Ed Marzan <ducojan...@aol.comwrote:

re: When DMAX and DMIN aren't enough...

Ed Marzan <ducojansen@aol.comwrote in
news:1181332944.135730.320600@e65g2000hsc.googlegr oups.com:
use the function fConcatenateChild() that you can find at many
places on the web.


--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

re: When DMAX and DMIN aren't enough...

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:

re: When DMAX and DMIN aren't enough...

Ed Marzan <ducojansen@aol.comwrote in
news:1181591481.416027.152140@u2g2000hsc.googlegro ups.com:
If you setup the fConcatChild() correctly it will place the data
the way you need it, whatever that way is. It will work calling
a query; that query can be designed to present the data in
whatever order you desire.


--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com