Hi all and thanks for your help.
I need suggestions:
I have collected a data in a table:
CODE_BANK and CODE_CLIENT
I use this table to extract data from other two tables: CLIENT and BANK.
For example:
record_1 -> CODE_BANK = 12345 and CODE_CLIENT = 112
The result of the query to extract the client 112 is:
code = 112 NAME = PAUL, SURNAME = ROBINSON
The same for the BANK.
Then i need to put the results of the queries in a word document.
This is what i do:
in vba, start the 2 queries (how can i pass the CODE_BANK / CODE_CLIENT to it??) that generates two temporary tables.
Then refer to these table to compile the word document.
I hope is clear, thank you.
I need suggestions:
I have collected a data in a table:
CODE_BANK and CODE_CLIENT
I use this table to extract data from other two tables: CLIENT and BANK.
For example:
record_1 -> CODE_BANK = 12345 and CODE_CLIENT = 112
The result of the query to extract the client 112 is:
code = 112 NAME = PAUL, SURNAME = ROBINSON
The same for the BANK.
Then i need to put the results of the queries in a word document.
This is what i do:
in vba, start the 2 queries (how can i pass the CODE_BANK / CODE_CLIENT to it??) that generates two temporary tables.
Then refer to these table to compile the word document.
I hope is clear, thank you.