Selecting nonadjacent records in Access

[DC]

Is there any way to select a group of nonadjacent records
in an Access table? The records I want to select have
nothing in common, so they can't be filtered. The "control
+ click" method doesn't work as it does in most Microsoft
products. Am I missing something REALLY simple?

 

[Van T. Dinh]

Sorry, no. Selection in the DatasheetView of the Table must be a contiguous
block.

 

[MacDermott]

Perhaps what you're missing is that Access is not really designed for the
user to work directly in the tables.
The tables are designed to store data; forms are for interacting with that
data.

On a form, you can build a multi-select listbox, which will let you select
any combination of records from your table.

HTH
- Turtle