Outputting to MS Word

R

Rob

I am outputting multiple reports to MS Word. Text boxes
in the report are based on a form and query. Sometimes
there are results in the underlining query and sometimes
not. Well if there is results from the query then the
information taken from form shows up in the Word
document. But if the results from the query is blank then
nothing from the form appears.

For example a text box on the report might be: =[FORMS]!
[Main Menu]![txtClientName].

I want the name of the client to show-up regardless of
whether query has results or not. Any help appreciated. I
just dont understand what once it is output to MS Word.
 
F

Fons Ponsioen

Like you say if the query output is blank than the report
does not put out data (that is not there). A Possible
solution is to generate a query where the client data is
always prsent even when the detail data may not exist.
This can be accomplished with the underlying query.
Hope this helps.
Fons
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top