Tables in a report

[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

 

[Allen Browne]

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.

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?

 

[Kevin Sprinkel]

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

in my report (including the column headings). Is is
possible to import it directly in a report?

 

[Larry Linson]

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

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?