G Guest Jun 26, 2007 #1 How can I query [Comments] and and return all of the record that contain the work "retired" or "Retired"? Thanks!
How can I query [Comments] and and return all of the record that contain the work "retired" or "Retired"? Thanks!
G Gary Jun 26, 2007 #2 How can I query [Comments] and and return all of the record that contain the work "retired" or "Retired"? Thanks! Click to expand... Try putting Like *retired"* in the criteria row of the query?
How can I query [Comments] and and return all of the record that contain the work "retired" or "Retired"? Thanks! Click to expand... Try putting Like *retired"* in the criteria row of the query?
M Michel Walsh Jun 26, 2007 #3 On comment (I imagine a Text, varchar, field), so, try under Comments field: LIKE "*Retired*" Hoping it may help, Vanderghast, Access MVP
On comment (I imagine a Text, varchar, field), so, try under Comments field: LIKE "*Retired*" Hoping it may help, Vanderghast, Access MVP
