Filter Query multiple field based on text box value

[ootkhopdi]

Hi ..

i want to create a filter query in which fields are

1. Name
2. ID
3. Account

My Form having Textbox is TxtAll

i want to run query where Name or ID or Account Value is equal or like as TxtAll

please tell me solotion soon

 

[arnelgp]

SELECT [ID], [Name], [Account] FROM yourTable WHERE [NAME] LIKE '*" & Forms!yourFormName!txtAll & "*' OR [Account] LIKE '*" & Forms!yourFormName!txtAll & "*'"

 

[ootkhopdi]

thanks for rply

please give me another solution for

i want to use creteria from two or more text box
i want to set as

if textbox 1 is null then creteria is value of textbox2

or if both are null then creteria is value of textbox3

how can i do it

pls give me solution