K
ktdid
Hello -
I am trying to write an append query that will look at 2 fields in a table.
One is an item number, the other is a field containing a number. Example:
first record field 1=item 1, field 2=3. Next record field 1=item 2, field 2
= 4. I would like to create an append query that adds item 1 to a table the
number of times that the number in field 2 equals. For example, in the table
I am appending to, item 1 would be added 3 times, item 2 would be added 4
times. How can I do this, please?
I am trying to write an append query that will look at 2 fields in a table.
One is an item number, the other is a field containing a number. Example:
first record field 1=item 1, field 2=3. Next record field 1=item 2, field 2
= 4. I would like to create an append query that adds item 1 to a table the
number of times that the number in field 2 equals. For example, in the table
I am appending to, item 1 would be added 3 times, item 2 would be added 4
times. How can I do this, please?