Tables in a report

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

Guest

A have made a query that returns me exactly what I want in my report (including the column headings). Is is possible to import it directly in a report

Daniel
 
You have a report already with all the right columns, and you want it to use
the query? If so, open the report in design view. Open the Properties box
(View menu), and set the RecordSource property (Data tab) of the report to
the name of the query.

Alternatively, you could switch your query to SQL View (View menu), and copy
the SQL statement into the RecordSource of the report.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Daniel said:
A have made a query that returns me exactly what I want in my report
Click to expand...
(including the column headings). Is is possible to import it directly in a
report?
 
Select Reports, New, Report Wizard, and select your query
from the Tables/Queries drop-down box, and follow the
prompts.

HTH
Kevin Sprinkel
-----Original Message-----
A have made a query that returns me exactly what I want
Click to expand...
in my report (including the column headings). Is is
possible to import it directly in a report?
 
It is certainly possible to create a report that uses the Query as its
RecordSource. That isn't "importing" but it certainly makes all the fields
from the query available to the Report. You can then arrange them as you
like (but it is, er, "unusual" for the column headings to come in the
RecordSource -- but certainly doable _unless_ you need specific numeric
formatting on some of the columns).

Larry Linson
Microsoft Access MVP


Daniel said:
A have made a query that returns me exactly what I want in my report
Click to expand...
(including the column headings). Is is possible to import it directly in a
report?
 
Back
Top