By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,190 Members | 843 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,190 IT Pros & Developers. It's quick & easy.

extracting data

P: n/a
Hi
I would like to extract only 15 records at a time from the backend in
alfabetic order. Click on a button and then the next 15. Reason data must
come over a 56k modem.

The data is not alphabetticaly in database.
Any ideas how to right such a function
thanks alfred
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Go to queries at the database window and click on New. Select the unmatched
query wizard. You want to find the records in the table you are extracting
from that are not in the table you are extracting to. Follow the
instructions to create the query you need. You don't need to extract in
alpabetic order because after you have extracted all the records you can set
the sort order to alphabetic when you use the records. After you have
created the query, right click in the query window, open qury properties and
set the Top property to 15. Finally, change the query to an append query to
append to the table you want to extract to. When you run the query, you will
extract 15 records that have not been previously extracted and add them to
the table you designated.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Alfred" <al***********@hotmail.com> wrote in message
news:cj**********@ctb-nnrp2.saix.net...
Hi
I would like to extract only 15 records at a time from the backend in
alfabetic order. Click on a button and then the next 15. Reason data must
come over a 56k modem.

The data is not alphabetticaly in database.
Any ideas how to right such a function
thanks alfred

Nov 13 '05 #2

P: n/a
"Alfred" <al***********@hotmail.com> wrote in message
news:cj**********@ctb-nnrp2.saix.net...
Hi
I would like to extract only 15 records at a time from the backend in
alfabetic order. Click on a button and then the next 15. Reason data must
come over a 56k modem.

The data is not alphabetticaly in database.
Any ideas how to right such a function
thanks alfred


Data in a database table has no inherent order, either alphabetically or
otherwise. It might 'seem' to be in some sort of order when you open up a
table, but it's not.
This example uses the products table in the Northwind database to do what
you want. This could get very slow on a large table. Make sure the product
name column is indexed.

parameters [page] int;
select p.ProductName,
(
select count(*) from products as p2
where p2.ProductName <= p.ProductName
) - (([page]-1)*15) as Row
from products as p
where
(
select count(*) from products as p2
where p2.ProductName <= p.ProductName
) between (([page]-1)*15 + 1) and ([page]*15)
order by p.ProductName
Nov 13 '05 #3

P: n/a
Are you talking about a ms-access database over a phone line, or is your
back end data on sql server?

You need to read up on the speed differences here between a office lan
(t100), and speed net (t1), and dialup t.056.

The above shows that a high speed t1 lines is 100 times slower then your
office network. And, the dial up is 1000 time slower.

You can read more about his here:
http://www.attcanada.net/~kallal.msn/Wan/Wans.html

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
http://www.attcanada.net/~kallal.msn
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.