Newbie - display query results

[Alan T]

I want to display the result of a query:
SELECT EmployeeNumber, FirstName, LastName, DOB, Address FROM Employee

What control I should put onto the detail band of the report?

 

[Duane Hookom]

Use text boxes to display field values. Set your report's record source
property to your query.

 

[Alan T]

I need to display the query report as master-details report, so I created a
report with master information such as
EmployeeName, Addresss, Phone

then put the sub-report onto that, this sub-report will contina the orders
that the employee created.
However, how do I make the sub-report expand itself?

 

[Alan T]

Ah, yes, the subreport expands itself.
But how do I display the header section? I put some text in the
header-section of subreport but it did not show on the main report.

 

[Duane Hookom]

Page sections don't display in subreports. You can create a fake page header
by creating a new primary sorting and grouping level in the subreport and
set its Field/Expression to a constant like
=1
Display the =1 group header and set its Repeat Section property to Yes.