Selecting different records

[Roger]

How do I select differents records at the same time in a Table?
I have Access (MS Office 2007)

 

[Pat Hartman]

When working with a database, it is customary to use queries to select the
data you need.

If you are talking about cntl-click and shift-click, you can select adjacent
rows only.

 

[Beetle]

That's not really enough information for someone to give you a good response.

What are you trying to do?

Do you want to view certain records based on some criteria?

Are you trying to update information on certain records?

 

[Roger]

Yes I want to select some records in order to print labels.

 

[Beetle]

Then typically you would create a query to select certain records based on
some criteria, then base your raport on that query.

HTH

 

[roccogrand]

Then Roger I would say that there are couple ways for you to select records
for labels.

If there is a temporal context for the labels, create a query that allows
you to select a start date and an end date for the people who will receive
the mailing. In the query builder, assuming that you have a field for the
date joined and a field for the date terminated, set each of these fields to
be a parameter query e.g., [Enter date joined] and [Enter date terminated].
When you run the query you will have to respond to both questions. Similarly
the parameters could be the month or year joined and/or terminated.

If there is a spatial context to the labels, you make want to use MapPoint
or another GIS to select records for the labels based on points within a
polygon, on a line, or nearest another point. Your GIS will dictate the
spatial query here.

If labels need to be prepared in an ad hoc manner, consider using a checkbox
on a form to iteract with the source data table or query. Then create a
query that prints labels only for the checked records. You'll also need an
Update Query to uncheck all of the records before the next mailing.

HTH

LDN