Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > SQL Language
|
SQL Language SQL Language discussions not specific to a particular RDBMS program or vendor.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Language section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 8th, 2007, 01:43 PM
Authorized User
 
Join Date: Dec 2006
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to brawny4
Default First Record in Access

How can I create a select clause in Access to give me only the first record back in my select? I know DB2 has a Fetch first fow only?

Please Help Thanks

mfb
__________________
mfb
 
Old February 8th, 2007, 01:46 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 196
Thanks: 0
Thanked 0 Times in 0 Posts
Default

SELECT TOP 1 ....

Rand
 
Old February 8th, 2007, 02:24 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 839
Thanks: 0
Thanked 1 Time in 1 Post
Default

What do you mean by "first"?

Jeff Mason
Custom Apps, Inc.
je.mason@comcast.net
 
Old February 8th, 2007, 03:14 PM
Authorized User
 
Join Date: Dec 2006
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to brawny4
Default

Thanks for the HELP!

mfb





Similar Threads
Thread Thread Starter Forum Replies Last Post
Incorrect Record updating in access zrtv VB Databases Basics 4 August 15th, 2008 09:26 AM
Add New Record in Access DB sidra Classic ASP Databases 1 June 2nd, 2008 01:13 PM
Seek record in Access sunny76 Access 3 February 21st, 2006 09:03 AM
Record number in Access Report Niaz Access 4 July 19th, 2005 01:48 PM
Access going to new record on close lryckman Access VBA 3 April 5th, 2004 10:29 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.