473,320 Members | 1,939 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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.
Jun 1 '21 #1
1 2870
NeoPa
32,556 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 :-(
Jun 1 '21 #2

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

Similar topics

3
by: 'bonehead | last post by:
Greetings, I'd like to figure out some syntax for retrieving the data from a table when I don't know all the of field names. What I do know are, the name of the table, the names of the primary...
2
by: Colin Colin | last post by:
We migrated our intranet site from IIS4 NT4 (\\GHCNT8) to a Windows 2003 server with IIS6 (\\NT58) using the IIS Migration Tools. I have a few ASP pages that access Foxpro data on a different...
4
by: Lefteris | last post by:
Hi, I am trying to write a simple application in javascript that automatically fills the fields of a form in a page at another domain. I display the foreign domain page on a frame and have the...
7
by: janet | last post by:
HI, We had some data which had low cardinality (86) , the count for that table is 9 million rows. How to optimize query which involve joining this table on that column? I'm not sure if...
1
by: Peter Monica | last post by:
I am trying to calculate distance from a point entered by a user usng a function in Access in a query that calls tables in an Oracle database as well as in Access. I am getting the following...
6
by: Jack Orenstein | last post by:
Suppose I have a table as follows: testdb=> \d person Table "public.person" Column | Type | Modifiers ------------+-------------------------+----------- id |...
2
by: dollyvishal | last post by:
How to get constraint information for MS Access tables using Query?
0
by: astersathya | last post by:
Date Format in MS Access using a query Hi I want to alter the existing column's format using the alter query. The issue I am facing is I want to set the default date format of an existing...
0
by: Kity1018 | last post by:
Hi, I have a webpage which has a detailsView control with no paging. On the page's button click event, I need to access one data field to make a desicion. I have the this detailsView bind to...
4
by: =?Utf-8?B?RHlsYW5TbWl0aA==?= | last post by:
I have a WebForm where I'm dynamically creating some controls and I'm having difficulty understanding how the state is being persisted and how to work with it. I've created a simplified example...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.