Reducing large table for export to Excel

[Guest]

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

 

[Guest]

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;

 

[Guest]

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.

 

[Guest]

Karl:

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

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

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