Query help (1 Viewer)

[rio]

I make a query with enter the parameter value box ( ). I have to put complete word ( PKAS Petrol 1002 ) or ( PKAS Diesel 1002) to filter the data from table tblProInfo ( View attachment TestQuery.mdb ). Is there any way that i can filter it .... by just insert Petrol or Diesel.

 

[vbaInet]

put an asterisk (*) before and after the word petrol or diesel. That is like this

*petrol* OR
*diesel*

 

[rio]

Thank for suggestion. what i means is parameter value box not criteria box.

 

[vbaInet]

Thank for suggestion. what i means is parameter value box not criteria box.

open the query and in the Criteria row of the field you want to perform the search on enter this:

Like '*' & [Enter a Fuel Type] & '*'

 

[rio]

Thanks....Thanks.....Thanks vbaInet.
Its working as i need.

 

[vbaInet]

Thanks....Thanks.....Thanks vbaInet.
Its working as i need.

Happy to be of assistance rio

 

[rio]

hi.. i got a new question... also about the query. Is there another way to make this ...

 

[vbaInet]

An explanation would be good? By the way, if you have paramters on one line in different fields it uses the AND logic.

 

[rio]

An explanation would be good? By the way, if you have parameters on one line in different fields it uses the AND logic.

Sorry my English not so good... and I don't know how to explain it in word... i think better using picture (make easier to understand)

here I attach the db... so can u show me how to do it.
View attachment TestQuery.mdb