473,324 Members | 2,473 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,324 software developers and data experts.

Find the differences

Ray
I had a query of table and achived it as a table a week's ago. Now I need
to find out if there are any modifications on the records against the
achived table. The modification might be one or several fields within the
records. There are no id fields in the tables. Can someone advise how to
accomplish this task.

Thanks,

Ray
Nov 13 '05 #1
3 1481
okay, so you archived a table, and then you want to see which fields in
your new table have changed... that's all easy... IF and ONLY IF you
have a unique identifier for each record that stays consistent between
archivings. If not, how do you know which record should match with
which? If you cannot do this, this is an unanswerable question.

If the primary keys/unique ID's are consistent then you can write a
little code to query the tables joining on the ID field and using
table1.[field n] <> table2.[Field n]. then you could just write that
information to another table.

If you followed Allen Browne's example of logging changes, you could
find them all that way.

Nov 13 '05 #2
Ray
Pietlinden,

Thanks for your reply.

We did it without plan so no id was added. Obviously under such situation,
human being is superior than the computer. We can check line by line to
find out the difference but it is an inefficient way to do. I would like to
use computer to check every fields of records and give me the result of
differences.

Ray

<pi********@hotmail.com> wrote in message
news:11********************@g44g2000cwa.googlegrou ps.com...
okay, so you archived a table, and then you want to see which fields in
your new table have changed... that's all easy... IF and ONLY IF you
have a unique identifier for each record that stays consistent between
archivings. If not, how do you know which record should match with
which? If you cannot do this, this is an unanswerable question.

If the primary keys/unique ID's are consistent then you can write a
little code to query the tables joining on the ID field and using
table1.[field n] <> table2.[Field n]. then you could just write that
information to another table.

If you followed Allen Browne's example of logging changes, you could
find them all that way.

Nov 13 '05 #3
Perhaps try a "Find UnMatched Query"

osmethod

Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

14
by: Bern | last post by:
what are all the diferences between the two?
2
by: AzGhanv/. | last post by:
Hi, I m searching for some Script / Function ... to find difference in data b/w 2 similar tables (exactly same fields structure) in sql 2000. plz update me asap ! thanks in advance !
13
by: Kieran | last post by:
I am designing a content management system and I want to make sure all pages entered into it's database by users are using valid HTML. I have designed the system to use HTML 4.01 Transitional...
2
by: Bob | last post by:
Don't tell me to "diff" the two standard's documents !
13
by: usenet | last post by:
How and where can one find out about the basics of VB/Access2003 syntax? I am a died in the wool C/C++/Java Linux/Unix programmer and I am finding it difficult to understand the program format...
4
by: rdemyan via AccessMonster.com | last post by:
I have to import building information from another system. I've decided to keep track of each set of data downloaded by including a Download_Date. That way I keep historical data. My table has...
23
by: thebjorn | last post by:
For the purpose of finding someone's age I was looking for a way to find how the difference in years between two dates, so I could do something like: age = (date.today() - born).year but that...
1
by: trpost | last post by:
I am looking for a way to find the differences between 2 multidimensional arrays. I have found ways to do this based on 1 key, but I want to be able to look at differences based on all keys: For...
5
by: Larry__Weiss | last post by:
Can a C# program find out what language an assembly (or components thereof) is written in? - Larry
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
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)...
1
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...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
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.