Search results

I am trying to create a query that capture all the possible choice of a fields and do some math on them. let me make it clearer. I have two fields that i need to create a query from forecast type(backup, hardcore) and win percent(76 to 100, 50 to 75, 26 to 49 and 0 to 25). Forecast type is a...

Does anyone know how to programmatically access the reset button in VBE. The reason for this is i have a query that uses a function. the query does what it suppose to do but when run it again the number keep increase instead of starting over. The number also start changes when you resize the...

Thanks for the help. Looks like this will solve most of the problem i have but i have one concern wont the second section get new record aswell ? because that is no difference from the code that you gave me earlier

thanks for the education. i think i start to get it let me see if i got idea correctly i think the only confusion i have right now is the left join. Let me see if i got it right. i cant see the immediate step, but i think i kind of get it. if there is no match then it will pad null to the...

i tested the code roy and seems to what you tell me Can you explain in detail how it works i thought. You can explain in in terms of math or set series theory i know union and intersection. The only thing that i am concern about is if there are two records in there that has same id but change...

The update table is actually imported list from a different system The reason for this logic is the the update list is actually data that is imported from a different system. the update data will be collect once a month and therefore they will not have the same update date on them. The only...

There will be a date field which will be the updated field The reason for this is to be able to see the changes. The historian acts as a log. Once i have the table i can just group them and count the occurance if there is more than one occurance than i know a change has occured for that...

Hope this picture allow you to see what i really want to accomplish Table Update ____________________________Historian ID Model Desc ______________________ID Model Desc 1 __ 2 __ House ______________________1 __ 2 __ House 2 __ 4 __ Car...

Your assumption is correct Thanks for the fast response and for codes let me check out the codes and see if it will works. One more question between sql and recordset which is a better approach? i mean when it comes to resources and speed. I have a programming background that why i choose to...

Code indent to show the flow Private Sub Command0_Click() Dim mycon As ADODB.Connection Set mycon = CurrentProject.Connection Dim rs As New ADODB.Recordset Dim rst As New ADODB.Recordset Dim closedate As Date Dim Deliverydate As Date Dim TES As String Dim Opp As String Dim Opp_Desc As String...

Psedo code Here is the psedo code: read first record in update table compare that record with records in historian. if it exist in the historian compare all the fields that the change can occured. if a change occured in any of the fields then copy it into a variable then go the next record...

Thanks for the fast response the reason i doing this is to be able to track the changes. I want to be see the difference but also able to track changes as well. The update file will be imported monthly and compare to the historian any changes will be added to the historian and new records that...

The code below is to compare two tables and see if there is any differences. one of the table act as a historian and the other as an update table. The historian will record any changes plus any new records that hasnt been stored in the database. I use two two ado recordset with one connection...

I create a front end and back end that resides on the lan. Front has everything besides the table which resides on the back end. Front ends table are linked to the backend. I have two computer that i am testing it on. Both of them runs Access 2003 runtime and windows has been update to the...