hubs
in [Queries]
|
From: subs on 31 Mar 2010 07:19 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
From: Tom van Stiphout on 31 Mar 2010 09:45 On Wed, 31 Mar 2010 04:19:39 -0700 (PDT), subs <subbu1678(a)gmail.com> wrote: What if there are multiple rows with a comment? Your criteria are not water tight. -Tom. Microsoft Access MVP >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
|
Pages: 1 Prev: 回覆: How could I SELECT the max of 2 different fields? Next: Time function |