filter a query with a number and text?

[Wrecker]

I need to filter a query that has both a number and text. I need to filter on the number only. example: "1115 machine Damage" . I need to bring in every time it see's 1115.

Thanks
Wrecker

 

[AlexMidd]

I take it from what you say the number is actually in text format in the same field as the rest of the text? Have fun! )

Alex Middleton

 

[Wrecker]

Yes ... that is correct

Wrecker

 

[AlexMidd]

Try criteria 'Like "1513*"' Have fun! )

Alex Middleton

 

[AlexMidd]

Sorry, like "1115*" Have fun! )

Alex Middleton

 

[Wrecker]

Not yet there.... need to filter by just the number...

Here are the codes as they appear.
1000 Testing Misc
1100 Cont / Dirt/ Oil / Lint
1440 Fog

I need the operator running the query to be able to punch in just the number in a "Like?" Box, and run the query. If I try 1100* it dosent bring back anything.

Thanks
Wrecker

 

[AlexMidd]

It will only work with number + "*". Try a query with a field called, say, NumToFind, and set its criteria to "[Enter Number:]". This should bring up a dialog asking the operator to enter the number. Then add the field with the data to be searched and set criteria for this to [NumToFind] & "*".

This should work in theory but I regret I haven't the time to test it. But it should work so fiddle with it and see what you get. Have fun! )

Alex Middleton