Collect data, query on it and export to file

michi.for

Registered User.
Local time
Yesterday, 17:46
Joined
Jan 13, 2016
Messages
45
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.
 
Data is in the form of a spreadsheet.
Why put in a word doc when the data is naturally in an Excel grid.
AND can be accomplished with a single command.
 
Hi,
after the queries i need to fill a document.

The problem is not "how to fill the document", but to execute the queries passing data to them.
 

Users who are viewing this thread

Back
Top Bottom