unique values (1 Viewer)

[slyvsspy]

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.

 

[Rich]

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

 

[slyvsspy]

Thanks

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

SELECT DISTINCT Voters.Precinct
FROM Voters;

 

[Rich]

And who keeps saying Access is slow?