R
Roger
How do I select differents records at the same time in a Table?
I have Access (MS Office 2007)
I have Access (MS Office 2007)
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
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.
data you need.
If you are talking about cntl-click and shift-click, you can select adjacent
rows only.
B
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?
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?
R
Roger
Yes I want to select some records in order to print labels.
B
Beetle
Then typically you would create a query to select certain records based on
some criteria, then base your raport on that query.
HTH
some criteria, then base your raport on that query.
HTH
R
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
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