468,467 Members | 2,664 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,467 developers. It's quick & easy.

Access Non-Matching Data Query Not Working

1
Her is a weird one. I have a database with th following query:
Expand|Select|Wrap|Line Numbers
  1. SELECT lines.Customercli, lines.fromdate, lines.todate, lines.Quantity, lines.costeach, lines.totalcost, lines.Description, lines.PTO, lines.dateadded
  2. FROM lines LEFT JOIN database1 ON lines.Customercli = database1.numbercli
  3. WHERE (((database1.numbercli) Is Null));
It has worked fine for years. However the computer died so we had to replace it, luckily the hard drive worked fine in the replacement PC, so everything is exactly as it was. Except for that one query, which now does not return any results.
I am at a complete loss, I have tried running the new query wizard with a whole new query, and it still does not work.
1 Week Ago #1
1 2167
NeoPa
32,092 Expert Mod 16PB
I assume you've checked that the data in the table (strangely) called [database1] has gaps in [numbercli] for some of the records found in the table [lines]? I can confirm that the SQL is exactly what you need for the task. I see no problems there - which is no surprise as it's been running for years already.

Unfortunately, what is different between before and now is unknown to you, so quite reasonably you haven't shared that with us. It's particularly unfortunate because without that we're on a bit of a hiding to nothing as far as helping you goes.

There are so many possibilities, but without some sort of pointer as to what may be different it's all but impossible to guess where the problem(s) may lie :-(
1 Week Ago #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by 'bonehead | last post: by
4 posts views Thread by Lefteris | last post: by
4 posts views Thread by =?Utf-8?B?RHlsYW5TbWl0aA==?= | last post: by
1 post views Thread by kmladenovski | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.