[thelist] Only display first 100 records from access

[Chris Blessing]

Paul-

I believe with Access you can use the TOP predicate in your sql statement.
So it would go...

SELECT TOP <n>...

SELECT TOP 100
Title,Initials,Surname,Company,Address1,Address2,Address3,Town,Postcode
FROM
MarketingFile

Chris Blessing
webguy at mail.rit.edu
http://www.330i.net

> -----Original Message-----
> From: thelist-admin at lists.evolt.org
> [mailto:thelist-admin at lists.evolt.org]On Behalf Of Paul Backhouse
> Sent: Thursday, January 17, 2002 11:21 AM
> To: thelist at lists.evolt.org
> Subject: [thelist] Only display first 100 records from access
>
>
> Hi people,
>
> Im helping a colleague at work - she's has been given a nasty access
> database with 999 records in it, which she was asked to copy the title,
> initials, persons name etc onto a label template by hand - now this would
> have taken her forever - so I suggested I might be able to help her out.
>
> Now, this email is going to be pretty long, because I will have
> to show you
> the code so you can see what I have done.
>
> I will place the code in the next email to cut down on text -
> apologises for
> anyone who hates long emails.
>
> So, my question is how can I only display the first 100 records from and
> access database - I though I knew, but it doesn't seem to work.
>
> For a demo of the site at present please refer to:
> http://work.2cs.com/unprotected/labels/
>
> You'll be able to see what I have done - its almost sorted, just
> needs to be
> shroten to select 100 records and display them - not the full database.
>
> Is this possible?
>
> Many Thanks
>
> Paul Backhouse
> 2Cs Communications UK Ltd
> www.2cs.com
> www.2cs.com/tradebridge
>
> The information contained in this message is confidential and may be the
> subject of legal, professional or other privilege. It is intended for the
> named addressees only and may not be disclosed to anyone without the
> sender's consent. If you are not the named addressee you must not use,
> disclose, distribute, copy, print or rely on the contents of this message
> and should destroy it immediately. If you need further information please
> contact the originator of this message on the number above, or e-mail
> postmaster at 2cs.com.
>
>
> --
> For unsubscribe and other options, including
> the Tip Harvester and archive of TheList go to:
> http://lists.evolt.org Workers of the Web, evolt !