Like "*" in statement (1 Viewer)

[ggovensky]

I have a query that pulls up infomation from a table.

The criteria is [Enter Program Number]

I need to make a Like "." for [Enter Program Number]

In a form which updates the table a user can enter in 1094 Argon Inter Express. I need it to be able to enter in just the 1094 or Argon, or Inter Express in the criteria .

Ex.

I pull a report from a query that shows 1094 (only) and show all the results.

Would the query have a criteria like [Enter Program Number]Like"*" ???

Please help
George

 

[marko]

Hi!

Actually, you were very close

It should say Like [Enter Program Number]
This way if you want everything that starts with Argon, just type in dialog box argon*

There was a very similar thread here

Cheers!