Moving a selection to another column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a question about moving selections. Sometimes I want to select
certain data in a column based on criteria in another column. For example,
In column B I have the following items: Red, Blue, green, Orange. In Column C
I have the either a number one or a zero. I want to be able to select all of
the number ones that are next to either a Red box or a Green box. I would
even be happy if I was able to select all of the boxes next to a Red or Green
box regardless of weather it is a one. The way I have to do it now is go
down by hand and select each number that box that lies next to a red or green
box and it takens to long to be useful.

Thanks, Aaron
 
I have a question about moving selections. Sometimes I want to select
certain data in a column based on criteria in another column. For example,
In column B I have the following items: Red, Blue, green, Orange. In Column C
I have the either a number one or a zero. I want to be able to select all of
the number ones that are next to either a Red box or a Green box. I would
even be happy if I was able to select all of the boxes next to a Red or Green
box regardless of weather it is a one. The way I have to do it now is go
down by hand and select each number that box that lies next to a red or green
box and it takens to long to be useful.

Thanks, Aaron
Click to expand...

Create a Query based on your table. You can enter criteria such as

=1

or

IN ("Red", "Green")

on the Criteria line under any field; Access will search for records
which meet those criteria.

John W. Vinson[MVP]
 
Back
Top