Show me these records

  • Thread starter Thread starter Tammy
  • Start date Start date
T

Tammy

Ok, I guess I didn't really post what I needed earlier.

I need to see the info in column a,b,c,d,e,f where column "c" contains
street name of "ivycrest"

and I have multiple streets.

How do I do this? Please help?
 
MS Access has records and MS Excel has columns. You would use a Query in
MS Access and Find in MS Excel.
 
Do you mean you have multiple streets in the same cell (Hope not), or that
you have multiple streets spread across a range of cells in Column C.

Assuming the latter, you can just select your headings, and do Data / Filter
/ Autofilter. Then just click on the dropdown at the top of your data in
column C and select the value 'ivycrest'. This will now show all the rows
where Col C contains that value.

Regards
Ken..............................
 
Back
Top