|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 26th, 2007, 03:40 PM
posted to microsoft.public.access.queries
|
|||
|
|||
Field Contains
How can I query [Comments] and and return all of the record that contain the
work "retired" or "Retired"? Thanks! 
|
|
#2
June 26th, 2007, 04:14 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Field Contains
On Jun 26, 7:40 am, Rod wrote:
How can I query [Comments] and and return all of the record that contain the work "retired" or "Retired"? Thanks! Try putting Like *retired"* in the criteria row of the query?
|
|
#3
June 26th, 2007, 04:35 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Field Contains
On comment (I imagine a Text, varchar, field), so, try under Comments field:
LIKE "*Retired*" Hoping it may help, Vanderghast, Access MVP "Rod" wrote in message ... How can I query [Comments] and and return all of the record that contain the work "retired" or "Retired"? Thanks!
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
