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

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

Re: Repeating data in Query result

Show all headers | View raw

Do you think I could do this within a table?  Do you have any suggestions?


On Tuesday, February 24, 2015 at 11:59:38 AM UTC-5, Patrick Finucane wrote:
> On Tuesday, February 24, 2015 at 9:51:19 AM UTC-5, csaved...@gmail.com wrote:
> > 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
> 
> I do not see how you can do that in a query.

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