[RESOLVED] Blank Recordset from Query with Data

[GaryMazzone]

Is the value your are seaching on a text or number field?

The % sign as a wildcard works like this:
If %4 Returns any thing ending in 4
If %4% Returns any thing with a 4 anywhere in it
If 4% Returns any thing with a 4 at the start.

So if you want a 4 in the second position then you need the single character wild card indicator ( an underscore _ )
If _4% returns any thing with a 4 in the second position followed by any thing.

[ChrisR873]

Thanks Gary, your post did work. Also thanks to Bruce, whose kinda gave me the right answer, but Gary helped explain it better.

The field is a text field being pulled from a table I cannot edit. So what I think happened is that because it is a text field, it makes whatever is inside the field text, even if I want them to be numbers. So I see now using the number wildcard wasn't working because technically they aren't numbers. Thus using the character wildcard works.

Now I can remove my workaround which will improve the reading speed with less record and my query is back to working like a query again! lol.

Thanks for the assistance.
~Chris