Searching Memo and matching against Multiple Criteria

[eddyc]

Hi, I want to search a cv field (data type memo) and match it against multiple criteria for instance - Administrator, Hospital, Degree etc ... this would be looking for someone who has experience in administration possibly in hospitals with a degree .... can anyone suggest the best way of doing this ... Is it in VB. I am thinking that i will need to parse the field into different categories and it may be very complicated but is there a reasonably simple way of doing this effectively as a stage one?

Cheers eddy

 

[DCrake]

You cannot search or filter ona memo field.

 

[eddyc]

Thats pants!!!! That realy true!?

 

[icemonster]

what do you mean? like search the contents of a memo field?

 

[Brianwarnock]

Do you mean
Where memofld Like"*Admin*" Or memoFld Like "*Hospital*"....
or
Where memofld Like"*Admin*" And memoFld Like "*Hospital*"....


Brian

 

[icemonster]

yeah or actually something that looks like this:

If Not IsNull(Me.txtSearch) Then
    If strWhereSql = "" Then
        strWhereSql = "WHERE qryCallLogList3.CALLLOGCOMMENT Like '*" & Me.txtSearch & "*'"
    Else
        strWhereSql = strWhereSql & "AND qryCallLogList3.CALLLOGCOMMENT Like '*" & Me.txtSearch & "*'"
    End If

End If

this one is actually from a database i worked on awhile back.
CALLLOGCOMMENT is a memo field. it can search existing text within the record's field.