473,327 Members | 2,012 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

maximaal aantal records uit query laten zien

In een formulier gebruik ik een query van meer dan 100 records. Hiervan
wil alleen de eerste 50 laten zien. Als een query een recordteller zou
bevatten, zou een eenvoudig criterium zijn
"teller < 50". Is er een functie om zo'n getal te krijgen? Of is er een
andere manier om de selectie aan een maximum te binden?

Jan 12 '06 #1
3 4430
<le*******@zonnet.nl> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...
In een formulier gebruik ik een query van meer dan 100 records. Hiervan
wil alleen de eerste 50 laten zien. Als een query een recordteller zou
bevatten, zou een eenvoudig criterium zijn
"teller < 50". Is er een functie om zo'n getal te krijgen? Of is er een
andere manier om de selectie aan een maximum te binden?

SELECT TOP 50 MyTable.F1, MyTable.F2 FROM MyTable
Jan 12 '06 #2
Hey Anthony

Using my code AND understanding Dutch also???
Are you *really* my evil twin????

;-)

Arno R

"Anthony England" <ae******@oops.co.uk> schreef in bericht news:dq*********@nwrdmz01.dmz.ncs.ea.ibs-infra.bt.com...
<le*******@zonnet.nl> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...
In een formulier gebruik ik een query van meer dan 100 records. Hiervan
wil alleen de eerste 50 laten zien. Als een query een recordteller zou
bevatten, zou een eenvoudig criterium zijn
"teller < 50". Is er een functie om zo'n getal te krijgen? Of is er een
andere manier om de selectie aan een maximum te binden?



SELECT TOP 50 MyTable.F1, MyTable.F2 FROM MyTable

Jan 12 '06 #3

"Arno R" <ar***********@tiscali.nl> wrote in message
news:43***********************@text.nova.planet.nl ...
Hey Anthony

Using my code AND understanding Dutch also???
Are you *really* my evil twin????

;-)

Arno R

"Anthony England" <ae******@oops.co.uk> schreef in bericht
news:dq*********@nwrdmz01.dmz.ncs.ea.ibs-infra.bt.com...
<le*******@zonnet.nl> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...
In een formulier gebruik ik een query van meer dan 100 records. Hiervan
wil alleen de eerste 50 laten zien. Als een query een recordteller zou
bevatten, zou een eenvoudig criterium zijn
"teller < 50". Is er een functie om zo'n getal te krijgen? Of is er een
andere manier om de selectie aan een maximum te binden?

SELECT TOP 50 MyTable.F1, MyTable.F2 FROM MyTable

Hi Arno
I don't really understand Dutch, just if you read it fast enough it sort of
looks like English, eg
....een query van meer dan 100 records... not too hard, is it?
I can assure you, though, I'm not your evil twin. I am the evil twin of the
person who is supposed to be working hard to earn some money for the family,
but is instead wasting his time on the newsgroups.

Jan 12 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Matt K. | last post by:
Hi there, I have a form in an Access project that contains a subform which displays the results of a query of the style "select * from where = #a certain date#". In the main part of the form...
1
by: PMBragg | last post by:
ORINGINAL Post >Thank you in advance. I'm trying to pull all inventory items from December >of the previous year back to 4 years for my accountant. I know this can be >done, but I'm drawing a...
6
by: Sven Pran | last post by:
Probably the answer is there just in front of me only awaiting me to discover it, but: 1: I want to build a query that returns all records in one table for which there is no successful "join"...
4
by: Brian | last post by:
I hope this will make sense. I'm trying to filter the records in a table based on records in a 2nd table. The trick is, I can't use a query. I'm trying to filter down the number of records going...
13
by: Jan | last post by:
Hi I have a database that I use to keep track of the sales promotions that we send to companies. I normally send a mailing based on a subset of the companies in the database (found using the...
1
by: VMI | last post by:
I need to display Access data in a datagrid but the Access table has over 2 million records. Since I can't fill a datatable with all those records but the user needs to see all of them, how can I...
11
by: shriil | last post by:
Hi I have this database that calculates and stores the incentive amount earned by employees of a particular department. Each record is entered by entering the Date, Shift (morn, eve, or night)...
5
by: slickdock | last post by:
I need to break my query into 3 groups: First 60 records (records 1-60) Next 60 records (records 61-121) Next 60 records (records 122-182) Of course I could use top values 60 for the first...
5
by: G33W1zz | last post by:
Hi, I'm trying to use foreach to write the results of a query to a csv file (fputcsv is not an option as my server is on php 4.7.4). Problem is that the second foreach returns ONLY the first...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.