How to select fields appear on report from multiple tables

[ges]

Hi,
I try to create report (ReportCollection) from 3 tables:
1. tblCollections (has 16 fields)
2. tblAgent (has 6 fields)
3. tblNotes (has 23 fields)
I created a query that contains all fields in this 3 tables. (total field 45
fiels)
I have a loaded/open form call frmCollection. User will key in information
in frmCollection which contains: cboAgent, optgrpFileType, Bill Cycle
parameter, and 9 options to sort the report (optSort).
I create a "view report" button so on click even will open ReportCollection.

In the reportCollection design view, on property control I pass the value
from frmCollection to ReportCollection for example:
=[Forms].[frmCollectionsDashboard].[txtFromBillCycle]

On ReportCollection detail section, I only want to show related information
around 4 to 6 fields filtered based on frmCollection.

QUESTIONS:
1. How do I select fields for each sort?
I try to use sqlSetup, then Me.Recordsource = sql Setup (contains sql
statements for each case)
but the details section show blank. (I've use debug.print sql and sql
statement is correct)

2. In details section do I need to create unbound textboxes? or what do I
need to do?

I greatly appreciate any help, thanks in advance.

Ges

 

[KARL DEWEY]

Open you report in design view, click on menu VIEW - Sorting and Grouping.
Select your sort fields and order (default ascending).

 

[ges via AccessMonster.com]

Karl,
Thanks for your reply. But how do I sort it automatically when user click
the button in the form that triger to open the report and it suppose to sort
the report based on information in the opened form, thanks

ges

Open you report in design view, click on menu VIEW - Sorting and Grouping.
Select your sort fields and order (default ascending).

Hi,
I try to create report (ReportCollection) from 3 tables:

[quoted text clipped - 28 lines]

Ges