Reducing large table for export to Excel

W

Wolfspaw

Access newbie. I have a table that contains 178,000 entries in a single
field. I want to select every tenth entry to reduce the total entries to
17,800 so that I can export it to Excel. How can this be accomplished?

Wolfspaw
 
K

KARL DEWEY

Access newbie. I have a table that contains 178,000 entries in a single
field.
I am assuming that you do NOT have that many entries in a single field but
have that many records with only one field.
Add a new Autonumber field. Use this query.
SELECT [Autonumber] Mod 10 AS Mod_Select, [YourFieldName]
FROM [YourTable]
WHERE ([Autonumber] Mod 10) = 0;
 
J

Jerry Whittle

If you don't already have field with a autonumber data type in the table,
create one.

In a query based on this table put the following as the criteria for this
autonumber field:
Like "*1"

NOTE: This can't be guaranteed to be exactly every tenth record or even
exactly 10% of the records. But it should be close.
 
W

Wolfspaw

Karl:

You are correct. Sorry for the poor use of terminology. Thanks for the help.

KARL DEWEY said:
field.
I am assuming that you do NOT have that many entries in a single field but
have that many records with only one field.
Add a new Autonumber field. Use this query.
SELECT [Autonumber] Mod 10 AS Mod_Select, [YourFieldName]
FROM [YourTable]
WHERE ([Autonumber] Mod 10) = 0;

--
KARL DEWEY
Build a little - Test a little


Wolfspaw said:
Access newbie. I have a table that contains 178,000 entries in a single
field. I want to select every tenth entry to reduce the total entries to
17,800 so that I can export it to Excel. How can this be accomplished?

Wolfspaw
Click to expand...
Click to expand...
 
Top