Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access 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 1st, 2007, 10:43 AM
Friend of Wrox
Join Date: Apr 2006
Location: Ternat, , Belgium.
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts
Default results shown by query


Is it possible to create a query were you can limit (or choose) the number of responses the query gives you.

Let me explain:

I have a table 'table1' with the fields 'Date' and 'Artikelnumber'. What I would like to do know is that I want to make different query's to obtain a number of results I want.

If in the table I have the records:

Date Artikelnumber
02/05/2007 1
02/05/2007 3
02/05/2007 12
02/05/2007 15
02/05/2007 16
02/05/2007 19
02/05/2007 30
02/05/2007 46
02/05/2007 58

Then I would build 3 different query's that give me as result a group of 3 records everytime. So the first query should give me the artikelnumbers 1, 3 and 12. The second one 15, 16 and 19 and the thirth one 30, 46 and 58.

I know I can work with top value's and top % in a query, but here I can't use these, because the first query should return me the first 3 values, the second one value 4 till 6 and the last one value 7 till 9.

Can this be done with a query or not?

Old February 4th, 2007, 12:45 PM
Friend of Wrox
Join Date: Apr 2006
Location: Ternat, , Belgium.
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts

Already found a solution myself...

Similar Threads
Thread Thread Starter Forum Replies Last Post
Edit Query Results in Results Grid druid2112 SQL Server 2005 1 June 28th, 2007 08:49 AM
different results were given for the same query madhusrp SQL Server 2000 2 May 9th, 2006 01:54 AM
SQL Server results not shown correctly ps2goat ASP.NET 1.0 and 1.1 Professional 4 October 21st, 2005 02:24 PM
Crosstab query with no results edubbelaar Access 0 November 22nd, 2004 06:12 AM
Refresh Query Results Ben Access VBA 2 February 10th, 2004 10:58 AM

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