I am pretty rusty at Access. I am trying to do something that I know should be pretty simple but I cant figure out how to do it.
I have a table I am trying to populate with records that are built off of 2 other tables. The table I am trying to populate is called "Instructions" and the tables I am using to populate it are called "Operations" and "Operands". The instruction table is a list of instructions that are made from Operations, and Operands. I want to create a string that is (Operation + ' ' + Operand +',' + Operand) that will hold all the combinations of instructions and operator. Example:
Operations
ID Name 0 MOV 1 ADD
Operands
ID Name 0 A 1 B
Using the above example I would want the query to create the following records
ID Instruction Name 0 MOV A,A 1 MOV A,B 2 MOV B,A 3 MOV B,B 4 ADD A,A 5 ADD A,B 6 ADD B,A 7 ADD B,B
My query filters out combinations where both operators are the same, but for illustrative purposes I left them in here. I can make a select query that will generate those results in an expression field, but when I try and convert it to an update query I can't figure out how to send the expression to a field in a the Instructions table. Any help is appreciated, thanks.