MS Access returning multiple rows

[ Follow Ups ] [ Post Followup ] [ Intranet eXchange ] [ IDM Home ]

Posted by Neil on August 8, 2000 at 16:4:9:

Now I am running a regular select query on the tables, comparing user numbers and selecting those that have equaly user numbers, printing that number and the ID number for that record. (users can have more than one record) Now I get 2700 records returned. All looks good. However if I go and try to sort the table by the end user number by clicking the az-arrow button it sorts the records fine but it eliminates the multiples of user number. The number of records goes from 2700 to 1200.

Anyone else seen this? Why does this happen? If I add other fields to select, the number stays constant when I sort the data. This new data is different on each record so I bet that is why it stays when I sort. But why does get rid of the mutliples when I sort?

Ideas?
Neil

Follow Ups:

• Re: Black Jack Jack Black 12:59:08 7/27/04 (0)
• Re: Car hire Car hire UK 16:19:39 7/22/04 (1)
  • Re: Good point mate! viagra Juan 16:10:29 8/04/04 (0)
• Re: Auctions Auctions 23:21:20 7/19/04 (0)
• Re: Airline Tickets Cheap Airline Tickets 05:35:16 7/16/04 (0)
• Re: Affiliate programs 13:40:35 7/15/04 (0)
• Re: Kontaktanzeigen 11:12:53 7/14/04 (0)
• Re: Viagra 09:40:04 7/14/04 (0)
• Cialis Cialis UK 06:16:19 7/13/04 (0)
• This will get yours up again! Viaga 05:48:42 7/09/04 (0)
• Follow up on the earlier thread about ... Viagra 12:38:39 7/08/04 (0)
• I'm lovin it! Reductil is my fatties best friend. Reductil 14:21:44 7/06/04 (0)
• asp with ms access as backend kamal deep 00:54:43 11/26/01 (4)
  • Re: asp with ms access as backend fdfd 02:43:35 2/21/02 (3)
    • Re: asp with ms access as backend Arjun Gyawali 08:42:47 8/22/04 (0)
    • Re: asp with ms access as backend sumit utreja 04:30:47 8/19/02 (1)
      • Re: asp with ms access as backend linda 07:39:26 9/16/03 (0)
• Re: MS Access returning multiple rows cecilia 16:29:24 7/10/01 (0)
• select one of multiple rows from table ihsan gunes 07:35:39 7/03/01 (0)
• select one of multiple rows from table ihsan gunes 07:34:13 7/03/01 (0)
• select one of multiple rows from table ihsan gunes 07:13:18 7/03/01 (0)
• Re: MS Access returning multiple rows Chris Davies 11:58:10 8/09/00 (20)
  • Re: MS Access returning multiple rows Adam J. Hable 12:14:48 8/09/00 (19)
    • Re: Black Jack Jack Black 07:24:48 7/27/04 (0)
    • Re: Diecast Cars Diecast Models 02:44:55 7/25/04 (3)
      • cheap car hire is funky cool dude! 11.08. 2004 19:44:02 cheap car hire Tim 13:44:03 8/11/04 (0)
      • Re: diecast is better than any stupid diecast Timothy 02:35:31 8/10/04 (0)
      • Re: Good point mate! viagra uk Juan 10:04:33 8/06/04 (0)
    • Re: Auctions Online Auctions 02:27:31 7/20/04 (0)
    • Re: Airline Tickets Airline Tickets 06:23:54 7/16/04 (0)
    • Re: Affiliate programs 14:24:09 7/15/04 (0)
    • Re: Viagra UK 11:04:44 7/14/04 (0)
    • Cialis Cialis UK 06:25:40 7/13/04 (0)
    • This will get yours up again! Viaga 05:55:26 7/09/04 (0)
    • I'm lovin it! Reductil is my fatties best friend. Reductil 14:12:33 7/08/04 (0)
    • Follow up on the earlier thread about ... Viagra 12:48:37 7/08/04 (0)
    • Re: MS Access returning multiple rows Denny Jackman 18:03:51 9/20/01 (0)
    • Re: MS Access returning multiple rows Chris Davies 05:10:13 8/10/00 (2)
      • Re: MS Access returning multiple rows weenieBoy 16:11:54 2/13/01 (1)
        • Re: MS Access returning multiple rows NewMarket Access Dude 09:14:14 3/28/01 (0)
    • Re: MS Access returning multiple rows neil 13:27:26 8/09/00 (1)
      • i have a problem chandan narayan 08:09:09 8/28/01 (0)
• Re: MS Access returning multiple rows Bryant McClellan 08:57:09 8/09/00 (2)
  • Re: MS Access returning multiple rows neil 11:18:44 8/09/00 (1)
    • Re: MS Access returning multiple rows Bryant McClellan 13:22:15 8/09/00 (0)

Post a Followup

Name:     
E-Mail:   
Subject:  
Message:

Optional Link URL: 
Link Title: