Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-access > #10410

Re: Repeating data in Query result

From "Ron Paii" <None@none.com>
Newsgroups comp.databases.ms-access
Subject Re: Repeating data in Query result
Date 2015-02-24 11:28 -0600
Organization A noiseless patient Spider
Message-ID <mcicad$t67$1@dont-email.me> (permalink)
References <1d846e68-473e-4578-90c5-40debd53e6cd@googlegroups.com>

Show all headers | View raw


<csavedgeebay@gmail.com> wrote in message 
news:1d846e68-473e-4578-90c5-40debd53e6cd@googlegroups.com...
> I've created a query to show open PO's.  The issue is there can be 
> multiple open PO's for one item.  In the Query result I would just like to 
> see the item and item identifying information once with the multiple open 
> PO numbers.  However, when I add in the open PO numbers my item 
> information begins to repeat.  Is there anything I can do about this?
>
> Example of what I would like to see:
>
> Item:      Desc:   Open PO NUM:
> 567589    Oxcarb    345
>                    568
>                    554
>                    445
>                    678
>
> Next item.

Use SELECT DISTINCT to remove the duplicates. Use a form or report to format 
and display the data.

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Repeating data in Query result csavedgeebay@gmail.com - 2015-02-24 06:51 -0800
  Re: Repeating data in Query result Patrick Finucane <patrickfinucanetx@gmail.com> - 2015-02-24 08:59 -0800
    Re: Repeating data in Query result csavedgeebay@gmail.com - 2015-02-24 09:08 -0800
      Re: Repeating data in Query result Patrick Finucane <patrickfinucanetx@gmail.com> - 2015-02-24 11:34 -0800
  Re: Repeating data in Query result "Ron Paii" <None@none.com> - 2015-02-24 11:28 -0600
  Re: Repeating data in Query result Norman Peelman <npeelman@cfl.rr.com> - 2015-03-01 08:11 -0500

csiph-web