查询或脚本以对所需数据进行排序。 [英] Query or script to sort data needed.

问题描述

Access 2003，Windows XP Pro


尝试在表格中取一个值字段，选择一系列记录，然后跳过一系列记录，然后选择一个新的范围附加到新表中的记录。


例如，如果我的初始字段中有100,000条记录，我想选择前1,000条记录，则跳过接下来的3,000条记录，然后选择接下来的1000条记录并继续执行，直到初始字段结束，将这1,000条记录集附加到新表中。


感谢您的帮助

Ron

Access 2003, Windows XP Pro

Trying to take one field of values in a table select a range of records and then skip a range of records and then select a new range of records to append into a new table.

For example, if my inital field has 100,000 records in it and I want to select the first 1,000 records then skip the next 3,000 records, then select the next 1,000 records and continue this until the end of the initial field appending these 1,000 record sets into a new table.

Thanks for any help
Ron

推荐答案

这是什么押韵和原因？

我们需要按照特定的顺序设置数据以进行打印进程和主要字段有数百万条记录

we need to set up the data in a specific order for a printing process and the primary field has millions of records

我的意思是，如果有某种过程用于确定哪些需要打印。最好是与表格中的实际内容相关的内容。或者，如果这些数字是常数并且永远不会改变。

What I meant is if there''s some sort of process you use to determine which ones need to be printed. Preferably something that relates to what''s actually in the tables. Or if these numbers are constant and will never change.

这篇关于查询或脚本以对所需数据进行排序。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！