Filter query / 3 fields

[anoo]

Can anyone please help me with this? Thank you.

I am using a form to input query parameters. (test file attached)

I used the following query (Returns all values on table when not filled)

Like "*" & [Forms]![Form1]![ListID] & "*"

Problem: entering 3 returns values of 3, 13, and 33. (Because of using "*")

How can I modify so that entering 3 only returns following value from the table:

3 one three

Thank you so much.

Anoo

 

[CJ_London]

remove the first *

 

[pbaldy]

If I'm a betting man:

[Forms]![Form1]![ListID] Or [Forms]![Form1]![ListID] Is Null

Leaving the second * will return anything that starts with 3 (30, 317, etc).

 

[anoo]

pbaldy, CJ_London: Thank you very much.

This worked:

[Forms]![Form1]![ListID]

 

[pbaldy]

Glad it worked, though I don't see it returning all records if left blank.

 

[anoo]

[Forms]![Form1]![ListID] Or [Forms]![Form1]![ListID] Is Null

Thank you, pbaldy. Your solution returns all records when blank.

 

[pbaldy]

No problem.