[AccessD] Union Query WHERE Bug?

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>


More information about the AccessD mailing list