[AccessD] Union Query WHERE Bug?

No, it's a text field. Some of the RepNum have letters in them.
 
Thanks,
Myke

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of StaRKeY
Sent: Friday, April 18, 2003 5:40 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Union Query WHERE Bug?


is the number actual text or a true number?
If it's a number you might try:
 

SELECT * FROM quniCEIncompleteCredits WHERE RepNum=8222
 
Regards,
Eric S.
 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Myke Myers
Sent: vrijdag 18 april 2003 21:53 
To: accessd at databaseadvisors.com
Subject: [AccessD] Union Query WHERE Bug?



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




  _____  

avast!  <http://www.avast.com> Antivirus: Outbound message clean. 


Virus Database (VPS): 17-4-2003
Tested on: 18-4-2003 23:40:06
avast! is copyright (c) 2000-2003 ALWIL Software.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030418/3e058189/attachment-0001.html>