Unmatched Query Wizard

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: kim (anonymous_at_discussions.microsoft.com)
Date: 03/08/04 

Date: Mon, 8 Mar 2004 10:47:19 -0800

i'm getting a wrong answer when i used the unmatched query
wizard based on 2 queries that are listing just unique
entries in 2 different tables.

so i changed the criteria of the matching field to "" from
Is Null, then the correct results were returned.

for other queries, 'Is Null' criteria works fine.

what's going on here?

my example:

in query 1, using table 1 [current or live database], only
unique entries were listed for field 1 [office name] and
field 2 [assigned tasks]

in query 2, using table 2 [previous database], only unique
entries were listed - field 3 [office name] and field 4
[assigned tasks]

i'm trying to identify any records that are differ between
[field 1 + field 2] and [field 3 + field 4]

i used '&"-"&' to temporarily merge two fields in the
queries. i didn't change table structures such as length
or data type, however.

thanks in advance...

Relevant Pages

  • Re: Check boxes and union queries
    ... You might want to provide and explain your SQL of the queries. ... MS Access MVP ... then all the entries that are not checked come ... > My second query uses the first query as a union - I want ...
    (microsoft.public.access.queries)
  • Re: Best way to sort arrays
    ... last entries ... In the first solution I use 2 extra queries and in the last soution I ... Could you not cut out the first query? ... If ordered backwards, start from the last key and ...
    (comp.lang.php)
  • RE: I have another question. Sorry.
    ... Christi Lee ... Generally you want to get valid data in as soon as you can. ... uses of your data where you don't want to look at the newest entries, ... queries, forms etc.) and then should take only seconds of your time to "do." ...
    (microsoft.public.access.tablesdbdesign)
  • 2003 - Address Book
    ... How can I make the address book include all contacts entries, ... Failing that, is there a quick way to enter a dummy email address into the empty ... Checked by AVG anti-virus system. ...
    (microsoft.public.outlook)
  • Re: Unmatched Query Wizard
    ... indexes on the implied field, and it would "break" if there ... > entries in 2 different tables. ... > for other queries, 'Is Null' criteria works fine. ...
    (microsoft.public.access.queries)