I have 2 tables with different versions in access. Both are same but the latest version obviously has some new records and some deleted records from the previous version. How would I compare the new table with the old one? I have a common field called MFI_ID having the value AT00100, AT10000 etc, in both the tables. I need to put the query and find out the new records in the new table as well as deleted records from the old table. The comparison is as follows (example):
Sheet.MFI_ID Sheet1.MFI_ID
AT00100 AT00100
AT10000 AT10000
AT12000 AT12000
AT14000 AT14000
AT14200 AT14200
AT14900 AT14900
AT15000 AT15000
AT16000 AT16000
AT17000 AT17000
AT18100 AT18100
AT18120 AT18120
CY151012 AT19230
CY151032 AT34000
FR0010137596 AT12312
CY155060 AT13452
5 1775 Rabbit 12,516
Recognized Expert Moderator MVP
A left join where Sheet1 is null will give you deleted records.
A right join where Sheet is null will give you new records.
Thanks again. Is there anyway these two could be used together in a query?
Addy
Rabbit 12,516
Recognized Expert Moderator MVP
No, you can't combine the two joins in that fashion. You can create two queries and then combine them in another query though. When you run the third query, it'll automatically run the first two.
Thanks for your help again. I really appreciate it.
Addy
Rabbit 12,516
Recognized Expert Moderator MVP
Not a problem, good luck.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Chris |
last post by:
Can anyone help me on this one?
I have a giant (couple thousand rows) HTML table.
Im trying to modify some of the cells innerHTML and/or innerText, but
it is taking a VERY long time to do so.
I believe that the problem is not with executing the code, but rather
with the browser reparsing the page, or the table, or something.
|
by: Toby Austin |
last post by:
I'm trying to replace <table>s with <div>s as much as possible.
However, I can't figure out how to do the following…
<table>
<tr>
<td valign="top" width="100%">some data that will 'stretch'</td>
<td valign="top" width="300">some data that won't 'stetch'</td>
</tr>
</table>
|
by: pembed2003 |
last post by:
Hi All,
Does C++/STL have hashtable where I can do stuff like:
Hashtable h<int>;
h.store("one",1);
h.store("two",2);
and then later retrieve them like:
|
by: Narra |
last post by:
Hi All,
I am trying to unload some 10 db2 tables from 2 environments and
then do a file comparison between them. Since SYSPUNCH card contains
all the information like field names, column length, position etc, i
have written a Rexx program that reads the SYSPUNCH and does a field
level comparison with the help of length and position fields. Same
way, repeating for the rest of unloaded tables.
Now, my problem is SYSPUNCH card doesn't...
|
by: Johan Tibell |
last post by:
I would be grateful if someone had a minute or two to review my hash
table implementation. It's not yet commented but hopefully it's short
and idiomatic enough to be readable. Some of the code (i.e. the
get_hash function) is borrowed from various snippets I found on the
net. Thee free function could probably need some love. I have been
thinking about having a second linked list of all entries so that the
cost of freeing is in proportion to...
| |
by: foolproofplan |
last post by:
I have a situation where I need to convert an xml file into two types
of tables in html. I have never done anything like this before, so I
have been reading up on it online. However, I am not 100 percent sure
where to begin.
Here is an example of an xml file I have:
<SquishReport version="1.2" >
<summary fatals="0" testcases="13" expected_fails="0"
unexpected_passes="0" warnings="0" tests="180" errors="0" fails="0"
|
by: Eep² |
last post by:
My 3D game comparison table is currently done without a database and is just a big complicated table (which I'd like to get sortable but the sortable Javascript I currently use can't handle the table correctly). Is there a better way to implement this table an to be able to automatically span exact results (i.e. "yes", "no", etc) across multiple rows/columns without having to use a database? I'd love to be able to just enter all the info into my...
|
by: ravi |
last post by:
Hi
can anybody tell me that which ds will be best suited to implement a
hash table in C/C++
thanx. in advanced
|
by: raylopez99 |
last post by:
A quick sanity check, and I think I am correct, but just to make
sure: if you have a bunch of objects that are very much like one
another you can uniquely track them simply by using an ArrayList or
Array, correct? An example: create the object, create an array, the
stuff the object into the array. Later on, assume the object is
mutable, the object changes, but you can find it, if you have enough
state information to uniquely identify...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |