Re: HELP--how do you select fields show in report based on opened form?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Uhm...

You have a tblNotes with 23 fields?

Most "notes"-related tables have 3 or 4 fields, maximum (ID, Author,
NoteDateTime, Note). There's a chance that your tblNotes table is not
well-normalized (but I can't tell because I tell what you are storing in
it).

Who cares?, you ask? You care! MS Access is designed to work with
well-normalized relational data. If you are feeding it spread*** data,
both you and Access will have to work much harder to do things that are
simple for well-structured data.

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

"ges" <u44973@uwe> wrote in message news:882ddf623b4e0@xxxxxx
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

--
Ges Khu
Geskhu@xxxxxxxxx
Access Beginner

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200808/1



.

Quantcast