Just shoot me and end my misery.....

[Kim]

My %$#$%^& boss has decided that he needs a custom report in the database I
somehow got elected to work on for the last 2 years. I know a little about
access at this point (thanks 2 these forums and some beginner classes), but
this is driving me nuts.

He wants the ability to choose a project(s), then add whatever fields about
that project that he chooses. (ex. address, contact, datestarted, and over 20
other possible fields).

Here's what I've got. I have a form that has a listbox to choose the project
name. I have 6 other combo boxes that you choose field names from the table.
My current report shows the project(s) you choose, but I have no idea how to
code the report/query to fill in the information from the fields i've chosen.
In essence, the report will show 7 fields, 1 being the project name and 6
being whatever the user chooses from the form.

Can this even be done? I'm in way over my head here, any help you can offer
is greatly appreciated. Thanks!

Kim

 

[Duane Hookom]

There is a complete ad-hoc/query by form applet at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. Your boss
will be able to choose fields, sorting, criteria, grouping, ... The results
are displayed in a datasheet subform with about 2 button clicks from sending
to Word, Print, Excel, HTML, Word Merge, Graph,...

 

[Kim]

Thank you. I actually found this while searching but didn't know exaclty what
I was looking at so I passed on by. Looks like I'll be able to stay out of
prison for running over my boss for a little while longer

Kim