If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Looking for changes in records after update
Hello,
I am trying to find changes in one table by using another table. The first table has the "live" data. The second table has the "historical" data. I am trying to find any changes that may have taken place after running an update query. The problem is, I need to find changes in the whole record, not just a single field, or I would use the unmatched query. |
#2
|
|||
|
|||
Looking for changes in records after update
On Wed, 29 Oct 2008 07:23:16 -0700 (PDT), martinmike2
wrote: You can still use the unmatched query, but first create two queries: each one for one of your tables, and it will concatenate all the table values into a single column: select CStr(CustomerID) & "-" & CustomerName & "-" & City & "-" & State ... etc. ... as AllData Then choose these two queries for the unmatched query. -Tom. Microsoft Access MVP Hello, I am trying to find changes in one table by using another table. The first table has the "live" data. The second table has the "historical" data. I am trying to find any changes that may have taken place after running an update query. The problem is, I need to find changes in the whole record, not just a single field, or I would use the unmatched query. |
#3
|
|||
|
|||
Looking for changes in records after update
Tom, It didn't work.
Here's what I have: Query2: SELECT CStr([bin] & ", " & [bsc] & ", " & [title] & ", " & [r_pnec] & ", " & [r_snec] & ", " & [a_rtabbr]) AS Astr FROM tblAMD; Query3: SELECT CStr([bin] & ", " & [bsc] & ", " & [title] & ", " & [r_pnec] & ", " & [r_snec] & ", " & [a_rtabbr]) AS Bstr FROM tblAMDHIST; Query4: SELECT Query3.Bstr FROM Query3 LEFT JOIN Query2 ON Query3.Bstr = Query2.Astr WHERE (((Query2.Astr) Is Null)); Reversing Query4 has no effect. Both versions produce no results, but I know there are at least 5 changes. Tom van Stiphout wrote: On Wed, 29 Oct 2008 07:23:16 -0700 (PDT), martinmike2 wrote: You can still use the unmatched query, but first create two queries: each one for one of your tables, and it will concatenate all the table values into a single column: select CStr(CustomerID) & "-" & CustomerName & "-" & City & "-" & State ... etc. ... as AllData Then choose these two queries for the unmatched query. -Tom. Microsoft Access MVP Hello, I am trying to find changes in one table by using another table. The first table has the "live" data. The second table has the "historical" data. I am trying to find any changes that may have taken place after running an update query. The problem is, I need to find changes in the whole record, not just a single field, or I would use the unmatched query. |
Thread Tools | |
Display Modes | |
|
|