i have a database with a million records. out of the million records there's 50 different precincts. I don't want to scroll through the million records and write down each different precinct.

Is there a way to run a query and pull off 1 of each of the fifty different precincts.

Shouldn't the precincts be in a separate table? You'll have to set the select query to unique on the property sheet and only add the precinct to the grid, a newspaper might help pass the time will it's running:)

but here's what I wrote and it only took a few minutes

SELECT DISTINCT Voters.Precinct
FROM Voters;

And who keeps saying Access is slow?;)