By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,204 Members | 1,360 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,204 IT Pros & Developers. It's quick & easy.

When DMAX and DMIN aren't enough...

P: n/a
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!

Jun 8 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
SELECT
item_name,
max(price),
min(price)
FROM
QueryYouMentioned

Cheers,
Jason Lepack

On Jun 8, 4:02 pm, Ed Marzan <ducojan...@aol.comwrote:
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!

Jun 8 '07 #2

P: n/a
Ed Marzan <du********@aol.comwrote in
news:11**********************@e65g2000hsc.googlegr oups.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

PA is y I've altered my email address.

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

Jun 8 '07 #3

P: n/a
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


Jun 11 '07 #4

P: n/a
Ed Marzan <du********@aol.comwrote in
news:11**********************@u2g2000hsc.googlegro ups.com:
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.
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.
On Jun 8, 5:43 pm, Bob Quintal <rquin...@sPAmpatico.cawrote:
>Ed Marzan <ducojan...@aol.comwrote
innews:11**********************@e65g2000hsc.googl egroups.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



--
Bob Quintal

PA is y I've altered my email address.

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

Jun 11 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.