[AccessD] Union Query WHERE Bug?

Messageis 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030418/8aeff572/attachment-0001.html>