hubs

[subs]

i have a table like

carrier service equipment price comment
hubs imdl 48 200 current
hubs imdl 48 500
hubs OTR 48 2899


now i need a query which can extract unique rows(for uniqueness, the
fields considered should be carrier,service,equipment). Als Whenever
the comment field has a value, then that row has to be selected.

So in the above example, the first row and the third rows are
selected. Second row is not selected because the first row which is
same in carrier, service and equipment has a value under comment
column.

Can somebody pls help me with a query

 

[Tom van Stiphout]

On Wed, 31 Mar 2010 04:19:39 -0700 (PDT), subs <[email protected]>
wrote:

What if there are multiple rows with a comment? Your criteria are not
water tight.

-Tom.
Microsoft Access MVP