selecting records

[Guest]

I want to select some records randomly for the purpose of printing.

I tried to use Ctrl, but it didn't work, and shift select the records
between the first selection and the last.

can any one help me please?

Thanks

 

[Duane Hookom]

Use a list box or add a yes/no field or add the primary key to a temporary
"Print Me" table or build a list of primary key values in a text box like:
12, 134, 87, 44
I prefer the List Box but it requires a little coding.

 

[Fred]

SELECT fields
FROM tables
WHERE primary key IN (123, 345, 278) Use whatever values you need to match.

 

[Guest]

Could you please explain a bit more ?

SELECT fields
FROM tables
WHERE primary key IN (123, 345, 278) Use whatever values you need to match.