I would need to realize the following thing:
- I have a fields of 7 char (code a) from table and I need calculate an othe field like this:
"0000"&right(code a,4) and to concantenate an incremental value (two char) until certain condition.
code a in table = "111abcd"
new fields = 0000abcd01, 0000abcd02,....0000abcd99.
I need to use a macro? how?
No problem. If you need help initializing a recordset, beginning an outer loop, and then nesting this loop inside, let me know.
I would need to code this:
For each register of a selection consultation (that relates several tables) I need to create
a new result table containing:
- each record from consultation
- generate a new record per each key using the algorithm (alredy sent).