Creating a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to create a report by attaching information from several
queries. (Example: a text box with the following: =Query1(firstname).
 
Yes, as long as the tables or queries can be linked with a common value. You
can either add other tables/queries buy clicking on the "..." (build) button
on the "Control Source" in the properties of the report itself and then
choosing the appropriate location. You can also add multiple sources by using
the wizard and cimply clicking "Back" when you have selected all the records
you need from the first table/query.
 
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

Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
how to pass a parameter to a query base of a query that is the base of a report 0
Access Command button to look up and copy data from a query to a table 0
Make query headings just contain field names? 1
Query on Query - put results onto report? 5
Error when trying to use calc field from Query 8
multiple queries and crosstab report 3
sorting a report with two tables 1

Back
Top