Connect report with query

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

Hi: How to connect a report which based on query. In my query data is
coming with multiple tables. And how to define fields in the report?


Thanks in advance.
 
Hi: How to connect a report which based on query. In my query data is
coming with multiple tables. And how to define fields in the report?


Thanks in advance.
Click to expand...

I'm not sure what you want to "connect"!

A Report has a "Recordsource" property, which can be the name of a
table or, actually more commonly, the name of a Query.

All of the fields defined in the Query are available in the "field
list" in the report designer and can be added to the report as
textboxes (or other controls, rarely).

John W. Vinson[MVP]
 
You must log in or register to reply here.

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

Similar Threads

Report Query Works 2nd Time, But Not 1st 14
Access Access Report Works on One Machine but not Another 3
Can't create a report from my query in Access 1
Too Many Fields Defined Error 1
Access 2000 report problem 1
report error message 1
Using a Parameter Query in a Report? 2
queries which pull data in multiple "rows" in one table and compar 2

Back
Top