Myke Myers
mmmtbig at bellsouth.net
Fri Apr 18 14:53:19 CDT 2003
Can anyone explain why this query returns one record, as it should... SELECT quniCEIncompleteCredits.* FROM quniCEIncompleteCredits WHERE (((quniCEIncompleteCredits.RepNum) Like "8222")); And this query returns no records?. SELECT quniCEIncompleteCredits.* FROM quniCEIncompleteCredits WHERE (((quniCEIncompleteCredits.RepNum)="8222")); Using Access 2000. 'quniCEIncompleteCredits' is a union query. TIA, Myke The Better Information Group -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030418/52965e52/attachment.html>