Access database Simple solution I hope???
Access database Simple solution I hope???
(OP)
I have a two database files which contain 5 identical fields. The first database has 4232 records. The second has over 17000 records. I need to merge the two, but first I need to increase the value of field5 by 423200 in every record of the larger database. I'll explain... The program that created these databases assigned a numeric value to field5 based on the position of the record in the original database. Both databases contain information that is not duplicated in either database, but must be combined into one database, with consecutive field5 values. field5 is a long integer numeric field. The value of field5 is not consecutive, but is more like 101, 102,103,105,201,202,203,204,205,206,207,301,302,303,304,305,306,307,308,401,402,403,404,501,505,508,509,510, etc... In each case, the last two (rightmost) digits must remain the same as the original number, (202 must be assigned a value of 452502, 505 will become 423805, etc...)
I don't have Access at home, but will be using the computer at work to do this on my files, and I don't even use it at work, but it's there and I honestly don't have the time to learn it just for this project. I can pay for the solution if needed. Any help is appreciated, even links to a site with clues to what I need to do.
THANK YOU in advance!
Brian
I don't have Access at home, but will be using the computer at work to do this on my files, and I don't even use it at work, but it's there and I honestly don't have the time to learn it just for this project. I can pay for the solution if needed. Any help is appreciated, even links to a site with clues to what I need to do.
THANK YOU in advance!
Brian





RE: Access database Simple solution I hope???
When yo merge, use the newly created field, and just ignore field5.
Assuming that filed5 is not a primary key.
RE: Access database Simple solution I hope???
RE: Access database Simple solution I hope???
CODE
Good Luck
johnwm
________________________________________________________
To get the best from these forums read FAQ731-376 before posting
Steam Engine enthusiasts: www.essexsteam.co.uk