Only showing fields with data in a query

[Guest]

I have a query that lists 3 different bidders, each of their base bid prices,
and 10 different alternate prices. What criteria would I use so that the
query only returns Each bidders name but only the alternates for which their
is a value entered?

Thanks,

 

[John Spencer (MVP)]

If your structure is Bidder, BasePrice, Price1, Price2, ..., Price 10 then there
is no reasonable way to do this. A row in a query has to return the same number
of elements. You could write a VBA procedure to concatenate the none blank
values into one field, but would that answer your need.

A different table structure would probably solve this for you.

TableBids
BidderID
Price
PriceType

Then you could just enter one row for each combination of bidder and pricetype
(Base, Alternate). IF you needed to output that in one row, you could use one
of the concatenate row functions that exist (Duane Hookom has a good one available).