var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: An Analytical Problem
I need your help on a little problem.
I have two tables TblMaster and TblLatest.
I want to update TblMaster with certain fields from TblLatest and also add any additional records that do not exist in TblMaster. They both have primary keys that will identify the records.
The fields i want to update are called "Codes" and "OtherCodes". Can someone help me. I have attached the 2 sample tables so you can understand what i mean.
In the attached file there are two queries. One for the appending of new records the other one is for your update.
NOTE: I changed the data type of ID in both tables to a number. Personally, I do not use a field with a data type Autonumber as a Primary Key due to the numbering may get out of sync.
Thanks Poppa Smurf,
I take it this is a standard Access function? yes you were right about the primary key. I put the table together as an example and forgot about that.
One more question, say if i wanted to remove all records that contained the firstname as Harry. How would i resolve that?
Again thanks for your help.
Last edited by aboo; 04-01-09 at 03:41.
You would use a DELETE query and in the criteria of the Firstname you would put "Harry"
Yet another question, can i put a multiple criteria, like "Harry,Jim,Terry" or do i need to seperate them?
You could put "Harry" and "Jim" and "Terry" in the criteria.
Actually it would be "Harry" or "Jim" or "Terry". Nobody would have all three names!!
Owner and Manager of
CypherBYTE, Microsoft Access Development Specialists.
Microsoft Access MCP.
And all around nice guy!
"Heck it's something understood by accountants ... so it can't be 'that' difficult..."
"...teach a man to code and he'll be frustrated for life! "