Re: How to design reporting?

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

Thanks for the input Jeff, I appreciate it.

In my case, I would then create 3 reports (3 queries - unscheduled,
scheduled, and completed) and build a form such as the one you described have
combo boxes for the 5 fields I wish the user to be able to search on? If
they don't select a parameter, will the query return all results for that
particular field?

"Jeff Boyce" wrote:

Derek

One approach I've used to add semi-custom reporting is:

* build the reports (I base mine on queries)
* make sure the reports (and their underlying queries) have the fields
needed for "customizing" (i.e., selection criteria)
* add the reports 'user-friendly names' and Access names to a new
tblReports table
* create a new form (frmOrderReports) that has a combobox that is filled
by the 'user-friendly names' (see previous step)
* add fields for the selection criteria you want your users to use re:
the reports
* add a command button that opens the report (Access Name) corresponding
to the 'user-friendly name' ... and that dynamically generates a WHERE
clause using the selection criteria fields/values.

NOTE: this is easier to outline than to do ... plan on spending some time
on this!

Good luck

Regards

Jeff Boyce
Microsoft Office/Access MVP

"DerekD" <DerekD@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C190C517-D054-45FD-9E9E-D4354A871859@xxxxxxxxxxxxxxxx
Jeff,

It was certainly not my intention to post multiple times, and it also was
not my intention to discourage any help. Each time I had submitted my
question, I was presented with an error message, so I retried my question.
Then, I after I logged in 15 mins later I was surprised to see they had
all
been posted. for my impatience I apologize.

Time is not a big factor here, and I didn't mean to imply that. I am just
interested in some input as to an efficient way to develop the reporting
functionality I am after while still allowing the user some ability to
limit
search results. Thank you.

"Jeff Boyce" wrote:

Derek

This, like the other public.access.xxxx newsgroups, is 'staffed' by
volunteers.

When you post this many copies of the same question/issue in such short
order, you are unlikely to encourage folks to lend a hand.

If you are under a major time constraint, perhaps you need to find
someone
to hire, rather than rely on volunteer assistance?

Good luck

Regards

Jeff Boyce
Microsoft Office/Access MVP


"DerekD" <DerekD@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6B22BB5F-0C25-473E-BFF8-6C1CE67C66B1@xxxxxxxxxxxxxxxx
I am developing a database (using Access 2003; file is Access 2000
format)
that is used to schedule and track completion of compliance courses for
our
employees. I have completed forms for scheduling, editing scheduled
courses,
and marking courses completed. I want to be able to report unscheduled
courses, scheduled but not completed courses, and completed courses. I
would
also like to have the results be able to be sorted by 1 of 5 criteria:
1. Manager
2. Location
3. Department
4. Course Title
5. Hire Date
In addition, would it be possible to allow the user to specify search
criteria to limit results? I am a novice user with some experience in
VBA
and SQL. I am just unsure the best way to go about designing this.







.

Quantcast