Query Syntax to determine if the value of one field is in other fi

		Home \| Contact Us \| FAQ \| Search & Site Map \| Link to Us
		Sign In \| Join \| Other 45 Sites in Network

Discussion Groups Forms Forms Programming Queries Modules / DAO / VBA Reports / Printing Macros Database Design Security Conversion Importing / Linking SQL Server / ADP Multiuser / Networking Replication Setup / Configuration Developer Toolkits ActiveX Controls New Users General 1 General 2

Access Directory Tools Tutorials User Groups

Related Topics

SQL Server Other DB Products MS Office More Topics ...

MS Access Forum / Queries / October 2007

Query Syntax to determine if the value of one field is in other fi

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bonnie - 31 Oct 2007 21:39 GMT

Hi,

I'm having a brain blip - in a query I would like to test if the value from
one field (example: Field 1: "ANN" Field 2: "ANN SMITH") is contained in
another field of the same table. If it weren't a field I would use LIKE.

Thanks in advance.

Bonnie

Reply to this Message

Bonnie - 31 Oct 2007 21:49 GMT

OOPS - don't want to waste anyone's time - I figured it out. I made a
calculated field in the query that is the result of
INSTR(table.field1,table.field2) with the criteria >0 and it works fine.

Thanks.

> Hi,
>
[quoted text clipped - 5 lines]
>
> Bonnie

Reply to this Message

Sign In

Join

My Latest Posts

My Monitored Threads

My Photo Gallery

My Homepage

Start New Thread

Enable EMail Alerts

Rate this Thread

©2008 Advenet LLC Privacy Policy - Terms of Use

This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.