Re: Database query, part of records

Article View: comp.databases.ms-access

Article #488

Back to comp.databases.ms-access Previous Next

#488

From: Jeff Cochran
Date: Mon, 30 Aug 2004 20:52

25 lines
1707 bytes

On 30 Aug 2004 13:06:33 -0700, peter@topcom.nu (Peter) wrote:

>Hello!
>I have some records in a database (access), like this:
>
>001111-10
>001111-11
>001111-12
>002222-10
>002222-11
>002222-12
>
>I need to retrive the first record of each sequence, "001111-10" and
>"002222-10" in the example above.
>
>Next part is I need to show only the first part of each record,
>"001111" and "002222" on an Active Server Page (ASP).
>
>Help with any part of this would be appreciated.

It's an ASP question, but you didn't post to any ASP groups.  In fact,
you hit only groups where this would be off topic.  Try posting to
microsoft.public.inetserver.asp.db

Jeff

Technical Details

Message-ID: <4137931f.602907435@msnews.microsoft.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.mathworks.com!enews.sgi.com!msrnewsc1!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl

References: <f6c505b5.0408301149.6e21dbb@posting.google.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: ff0ac,fe8adce8f4807dcf
X-Google-Thread: 10ef2d,fe8adce8f4807dcf
X-Google-Thread: f4d39,fe8adce8f4807dcf
X-Google-Thread: 1131db,fe8adce8f4807dcf
X-Google-Attributes: gidff0ac,gid10ef2d,gidf4d39,gid1131db,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: jeff.nospam@zina.com (Jeff Cochran)
Subject: Re: Database query, part of records
Date: Mon, 30 Aug 2004 20:52:09 GMT
Organization: City of Naples, Florida
Message-ID: <4137931f.602907435@msnews.microsoft.com>
References: <f6c505b5.0408301149.6e21dbb@posting.google.com>
X-Newsreader: Forte Agent 1.5/32.451
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: comp.databases.ms-access,forum.sqlbase,microsoft.public.inetserver.iis,mailing.database.sql-general
NNTP-Posting-Host: ns1.naplesgov.net 209.26.8.10
Lines: 1         
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.mathworks.com!enews.sgi.com!msrnewsc1!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl

Reply to Parent Message