 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / May 2006Expression in Query
I have 6 fields in a query. All fields come from one source table. If there is a change to any of those 6 fields weather it be one filed or all 6 fields. What type of expression can I put into the criteria to catch the change and update it to another target table. I just need the expression part. I was thinking under each field some like this..<>[productsTable].[productId] and under description field.. ..<>[productsTable].[Description]and so fourt. Would this work to capture the changes then use an update query to move the data? Thanks in advance How would you be able to tell if a field was changed in a query? All you are pulling is the current value for each field. What would you compare it to? The only way I know to handle this is in the form. You can create code to write the old value when a change is made. For more details, search for previous posts. Look for "audit trail".  SignatureRick B >I have 6 fields in a query. All fields come from one source table. If there > is a change to any of those 6 fields weather it be one filed or all 6 [quoted text clipped - 7 lines] > ..<>[productsTable].[Description]and so fourt. Would this work to capture > the changes then use an update query to move the data? Thanks in advance No if a person updates say a field in a form. I write the query to check and see if any fileds I palce in my query (from a form) has chaged. If so I run an update query to update that field. I just want to know how to check and see if a field has been updated such as the expression I put above. > How would you be able to tell if a field was changed in a query? All you > are pulling is the current value for each field. What would you compare it [quoted text clipped - 15 lines] > > ..<>[productsTable].[Description]and so fourt. Would this work to capture > > the changes then use an update query to move the data? Thanks in advance I have no idea what you are trying to do. Sorry, hopefully someone else will be able to jump in. You might want to give us an example (in case others are as lost as I am). What are your fields? What is an example of a record with data in the fields? If the user tries to change a value in a field, what will you compare the entry to? SignatureRick B > No if a person updates say a field in a form. I write the query to check > and [quoted text clipped - 28 lines] >> > the changes then use an update query to move the data? Thanks in >> > advance |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.