Find txt in column

[jaiD]

Hi, i am really new to access but very fluent in excel. My problem is I have data lines of 330,000 which would obviously not fit into an excel sheet.

I am trying to do either of the following:

Highlight all lines of data which have the following text in them golf club, ie

(for example 4 columns)
Tel No Addresss Name Post Code

xxx xxx stoke golf club xxxx
xxx xxx stoke football club xxxx

So i would like it to highlight all of the lines with golf club in the name column.


Other option would be to run some sort of query to add up number of times golf club appears in the name column?


Please remember my knowledge is pretty basic?

Thanks in advance for any work

 

[MyBoo]

Create a query based on the table that contains your data.
In the criteria section of the field that may contain "golf club" (I guess that's your Name field)... enter:

Like *golf club*

Run the query

Like *golf club* acts like a filter... selecting all records where the Name field contains "golf club"...

HTH

 

[jaiD]

thank you that was a big help, worked perfectly