Record Selection in a table

[pezman38]

I created a couple database tables to link with my RF scanner for use in a warehouse.

Is there anyway that I can take a masterfile table and select 100 records, cut them out and paste them into a new table to import into the handheld?
I am pretty sure there is a way, just don't know where to start. I didn't think the macro's had that functionality, and since I have very little VB programming I have been forced to rely on Access functionality.

Any help would be accpreciated.

 

[M8KWR]

you can do a query to select 100 records, but is there a criteria for this 100 records.

To select 100 records in a query, go into the design view, right click in the top part where the tables/queries are shown, and select properties.

In here there is an option for TOP values, change this to 100 or what ever you require.

Or if you are using SQL to build the query then put TOP 100 after the select at the start, so "SELECT TOP 100"

I hope this helps