Query criteria from a form that has wildcards

[healthmj]

I have a query that gets the criteria from a combo box on a form. The problem is that I need to use wildcards (e.g., 046.????). The query works if I use one number (e.g., 046.0005). Anyone have ideas how to make a query run using wildcard data from a form?

Thanks in advance

Mike

 

[Darrylles]

Hi,

Witin a query, then 'LIKE' should be used to return values like a criteria string.

In your case, you need to decide on numeric's and must decide what you would accept as 'like'.

Is it anything LARGER than 46.000 or SMALLER than 46.000 or <= 46.000 or >= 46.000 etc.

The criteria for the query determines what data will be returned.

Regards,

Darrylle &quot;Never argue with an idiot, he'll bring you down to his level - then beat you with experience.&quot; darrylles@totalise.co.uk