"Like" Query

[satty]

orite' dudes,

i was wondering if it was possible to create 'like' queries. i dont actually know what they're called so im refering to them as LIKE. :wink: .

i want to create a query in which i am prompted to enter the Member name.

for example

i have members: John Smith & John Smite. however in the parameter box if i enter SMI then records for all LIKE MATCHES are shown? i know its possible ive forgotten how ta do this .

Thanx,


SaTTy

 

[ChrisUK]

It's called just that!

The SQL you want is:

SELECT * from tablename WHERE column-name LIKE 'smit*'

If you're filling out a test box just add the * and let access do the rest

HTH

 

[SydneyGeek]

In the query grid, below the surname field, enter this in the criteria:

Like "*" & [Enter the surname or part surname] & "*"

This will pop up a parameter prompt, allowing you to enter SMI and get your 2 names back.

If you want to use a textbox instead, change this to

Like "*" & [Forms]![MyFormName]![MyTextBoxName] & "*"

change form and textbox refs to suit.

HTH
Denis