 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / June 2007Comparing data before updating
Does anyone know how to compare data? If same update the quantity else just ignore it? >Does anyone know how to compare data? >If same update the quantity else just ignore it? Emily, don't you have that backwards? If it's the same, then updating it will change 123 to 123. Please explain WHAT you are comparing to WHAT, and under what circumstances; and what you want to update, and what you want to update it to. Remember: YOU can see your database. YOU know what problem you're trying to solve. We cannot, and we do not. All we can see is the two lines of text you've typed - and maybe I'm just sleepy, but those two lines simply don't make sense to me! John W. Vinson [MVP] I am sorry about this... Really sorry... Ok...I will explain to you right now.. I hope you can help me as I have tried a lot of method but still can accompalish what I want. Well, actually the purpose I am doing this is I want to differentiate between new and old job... Well, I cannot completely replace the old job to the new one because some part number appear in new and old too... So, that is why I need the new job to get the quantity kitted from the old job where both of the part number exists for both job... For example, A job number AG123 has the following part number needed to built that job:- 10122-8900 12345-0990 11111-1111 Then for a new job under the same category, i put it as AG789 need the following part number:- 10122-8900 00001-0000 So, I need the quantity kitted of 10122-8900 from AG123 to be transfered to AG789.... Actually AG789 is the extended on AG123... Note : There will be a column on the kitted quantity..just that I didnt show it...but most important is the comparison part... Will have a form prompt the user to enter the old and new job. Once the button is being click, it will get all the quantity where the part number exist in both of the job.... Clear? Hope to hear from you soon... >>Does anyone know how to compare data? >>If same update the quantity else just ignore it? [quoted text clipped - 11 lines] > > John W. Vinson [MVP] >I am sorry about this... >Really sorry... [quoted text clipped - 29 lines] >button is being click, it will get all the quantity where the part number >exist in both of the job.... I'm still not understanding your table structure. You have a Job table. What fields are in the job table? You have a table - somehow - relating Jobs to the parts required for that job. What fields are in this table? What does "kitted" mean? I *THINK* you'll be able to create a Query on the Job table (with a criterion of the job you'll get quantities from), joined to the JobParts table (which I presume exists), joined by part number to a *second* instance of the JobParts table, joined to a second instance of the Job table with a criterion of the "to" job. But since I don't know the structure... I'm not sure how or whether this can be done. It sounds like you're setting up a quite complex application. I'd really suggest that you may want to hire a professional with good database skills, preferably someone local who can come into your facility and actually see what you're doing and how. It's never easy to communicate over the internet, but when you're talking in a jargon that I don't understand, and I'm talking in a jargon that you don't understand, and we're talking about something as difficult as this project, it's especially problematic! John W. Vinson [MVP] Haha...OkOk/.... Glad that you actually replied... Thanks for your attention ya... >>I am sorry about this... >>Really sorry... [quoted text clipped - 29 lines] > > John W. Vinson [MVP] |
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.