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

I'm still not convinced that the table is well-normalized. It seems to me
that you could use a single field to hold an "action", a single field to
hold a "collector", and a single field to hold "date action was taken", plus
maybe a rowID field.

If you'll provide a bit more information about the kind of data that is
being stored in these fields, we may be able to offer an easier way. I'm
not trying to be difficult, just pointing out that if your data isn't
structured the way Access expects it to be, you (and Access) will have to
work MUCH harder than you othewise would.

For example, I can use my chainsaw to drive nails ... but it isn't pretty or
safe or the right tool for the job...<g>

Regards

Jeff Boyce
Microsoft Office/Access MVP

"ges via AccessMonster.com" <u44973@uwe> wrote in message
news:883aa4b89277c@xxxxxx
Hi Jeff,
Thanks for the reply. Yes believe it or not but I do have 23 fields in
table
Notes. My client is collections company, we are using table notes to
store
all the actions and dates taken by collector.
so of course I can't put all those fields in the report. So my client
would
like the option to select fields that will show in report based on the
selection in the open form. I never do report thru vba, this if my first
time.
.Can you help?

Thanks,
Ges

Jeff Boyce wrote:
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

Hi,
I try to create report (ReportCollection) from 3 tables:
[quoted text clipped - 32 lines]

Ges

--
Ges Khu
Geskhu@xxxxxxxxx
Access Beginner

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



.