Why am i getting Null fields with this query?

[sportsguy]

Like "*1083*" Or Like "*4048*" Or Like "*1083*" Or Like "*4049*" Or Like "*4050*" Or Like "*4052*" Or Like "*6001*" Or Like "*6464*" Or Like "*8602*" Or Like "*8603*" Or Like "*8609*" Or Like "*8627*" Or Like "*8628*" Or Like "*8629*" Or Like "870*" Or Like "871*" Or Like "872*" Or Like "873*" Or Like "874*" Or Like "876*" Or Like "*,870*" Or Like "*,871*" Or Like "*,872*" Or Like "*,873*" Or Like "*,874*" Or Like "*,876*" Or Like "*8751*" Or Like "*8752*" Or Like "*8753*" Or Like "*8757*" Or Like "*8758*" Or Like "*8759*" Or Like "*8770*" Or Like "*8776*" Or Like "*8800*" Or Like "*8805*" Or Like "*8806*" Or Like "*8808*"

i can't figure this out. . .

 

[GohDiamond]

Do you have other criteria in your same query that may be running at a higher priority which does pull some NULL values in the recordset?

I tested your criteria above to make sure that some syntax wasn't causing the issue and found it to work ok applied to a table with thousands of PO IDs and Invoice Numbers

I think something else must be happening in the query

Just Saying,
Goh

 

[GinaWhipp]

It would help to see the whole query, this part doesn't give the whole story...