Criteria

[Guest]

Hi,

I have a parameter query that I would like it to show the combined words or
numbers.

Ex: I entered SR#1,17,CB's at the first record, SR 1,16,17,32 all PB's in
the second record and SR 1, 16 TE's in the thirst record in the PROCEDURE
field.

If I enter 17 in the pop up box, it should show the first record
(SR#1,17,CB’s) and the second record (SR 1,16,17,32 all PB's).

Or if I type in SR in the pop up box, it should show all three records
because three of them have the SR .

Would you show me what the criteria I should use?
Thanks
Chi Huynh

 

[Guest]

You should use Like in the criteria

Like "*" & [Please select a value] & "*"

The user will be prompt with the massage to [Please select a value], and the
query will list all the records that contain that string

 

[Guest]

Thank you so much! It works!!!!! Excellent!

I also thanks for your quick respond
Chi

You should use Like in the criteria

Like "*" & [Please select a value] & "*"

The user will be prompt with the massage to [Please select a value], and the
query will list all the records that contain that string

--
Good Luck
BS"D

Hi,

I have a parameter query that I would like it to show the combined words or
numbers.

Ex: I entered SR#1,17,CB's at the first record, SR 1,16,17,32 all PB's in
the second record and SR 1, 16 TE's in the thirst record in the PROCEDURE
field.

If I enter 17 in the pop up box, it should show the first record
(SR#1,17,CB’s) and the second record (SR 1,16,17,32 all PB's).

Or if I type in SR in the pop up box, it should show all three records
because three of them have the SR .

Would you show me what the criteria I should use?
Thanks
Chi Huynh

 

[Guest]

Your welcome, glad I could help

--
Good Luck
BS"D

Thank you so much! It works!!!!! Excellent!

I also thanks for your quick respond
Chi

You should use Like in the criteria

Like "*" & [Please select a value] & "*"

The user will be prompt with the massage to [Please select a value], and the
query will list all the records that contain that string

--
Good Luck
BS"D

Hi,

I have a parameter query that I would like it to show the combined words or
numbers.

Ex: I entered SR#1,17,CB's at the first record, SR 1,16,17,32 all PB's in
the second record and SR 1, 16 TE's in the thirst record in the PROCEDURE
field.

If I enter 17 in the pop up box, it should show the first record
(SR#1,17,CB’s) and the second record (SR 1,16,17,32 all PB's).

Or if I type in SR in the pop up box, it should show all three records
because three of them have the SR .

Would you show me what the criteria I should use?
Thanks
Chi Huynh